Prev: the value should not be more than 0.8
Next: Help with blank cells when concatenating
From: Subbu on 5 Jul 2008 08:00
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 5 Jul 2008 08:07
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: farid2001 on 6 Jul 2008 00:33
If you have Excel 2007 it's quite simple, just use CountIFS instead of
CountIF, I think you can have up to 56 conditions, so it's really quite a
powerfull function. CountIFS and SumIFS are functions not available in Excel
2003.
I really love them both.

Regards
farid2001



"Subbu" 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
 | 
Pages: 1
Prev: the value should not be more than 0.8
Next: Help with blank cells when concatenating