Prev: sorting array formula
Next: Trying to work out the difference in 2 cells.
From: Subbu on 6 Jul 2008 05:21
Thank you very much Pete_UK
Great guidance given by you



"Pete_UK" wrote:

> COUNTIF is limited to one condition only. Do it this way instead:
>
> =SUMPRODUCT((condition1)*(condition2)*(condition3))
>
> where condition1 might look like:
>
> (A1:A100>TODAY()-30)
>
> for example, if you are interested in a date in column A falling
> within the last 30 days.
>
> Hope this helps.
>
> Pete
>
> On Jul 5, 1:00 pm, Subbu <Su...(a)discussions.microsoft.com> wrote:
> > How to get result by using CountIF, if there are 3 conditions to be met? I
> > want to get the number of occurances with 3 or more conditions to be checked!
> > Please help
> >
> > Thanking you
>
>
From: Pete_UK on 6 Jul 2008 06:15
You're welcome, and thanks for the kind comments.

Pete

On Jul 6, 10:21 am, Subbu <Su...(a)discussions.microsoft.com> wrote:
> Thank you very much Pete_UK
> Great guidance given by you
>
 | 
Pages: 1
Prev: sorting array formula
Next: Trying to work out the difference in 2 cells.