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

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
 
P

Pete_UK

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
 
F

farid2001

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning a value if multiple conditions are met 2
Countif, multiple criteria 6
Two Condition - search 2
Excell - two conditions count if factors are true when negative nu 2
Excel How to count from a column if specific condition in another column is true 3
sumproduct with 4 conditions 1
sum/group by 2 conditions 4
Finding the weighted average of text that have been given values 1

Top