Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIFS Formula Problem
Has anyone experienced any substantial errors from the Countifs Formula?
A B C 1 15 51 30 3 20 30 18 4 20 15 18 5 15 51 30 COUNTIFS(A3:C3,A1,A4:C4, B1,A5:C5, C1) = 0 when it should equal 1 Is my syntax wrong? This what the formula produces? Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countifs | Excel Discussion (Misc queries) | |||
PLS HLP! Countifs Syntax Problem? | Excel Worksheet Functions | |||
Averageifs & Countifs | Excel Worksheet Functions | |||
2 COUNTIFS | Excel Discussion (Misc queries) | |||
Multiple countifs | Excel Worksheet Functions |