How to get result by using CountIF, if there are 3 conditions to b

  • Thread starter Thread starter Subbu
  • Start date Start date
S

Subbu

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
 
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
 
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
 
Back
Top