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

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

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

COUNTIF is limited to one condition only. Do it this way instead:

=SUMPRODUCT((condition1)*(condition2)*(condition3) )

where condition1 might look like:

(A1:A100TODAY()-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 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

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

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

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

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:A100TODAY()-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 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

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

You're welcome, and thanks for the kind comments.

Pete

On Jul 6, 10:21*am, Subbu wrote:
Thank you very much Pete_UK
Great guidance given by you