Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |