Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
return a result from multiple conditions. | Excel Worksheet Functions | |||
how to return a result from 2 conditions? | Excel Worksheet Functions | |||
How do I set up multiple logical conditions on one result cell | Excel Worksheet Functions | |||
2 Conditions True, Many Variables, Return Result | Excel Worksheet Functions |