Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF / AND functions
the COUNTIF and AND functions are already combined for you in the COUNTIFS
function. COUNTIFS(range1, criteria1, range2, criteria2, etc). it will only count the number of times that all conditions are met at the same time. i'm no expert but hope that helps took me a while before i figured that out too. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf Functions | Excel Worksheet Functions | |||
Countif & AND functions | Excel Worksheet Functions | |||
COUNTIF & AND Functions | Excel Worksheet Functions | |||
COUNTIF / AND functions | Excel Programming | |||
CountIf functions | Excel Discussion (Misc queries) |