Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Error
=COUNTIF($X$35:$X$2000,AC15),($Y$35:$Y$2000,AC15), ($Z$35:$Z$2000,AC15),($AA$35:$AA$2000,AC15)
WHAT i AM TRYING TO DO IS...LOOK IN ALL FOUR COLUMNS X,Y,Z,AA BETWEEN ROW 35 AND 2000, LOOK FOR A DATA # THAT CORRESPONDS WITH AC15..AND ADD THEM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula returns error; abbreviating the formula | Excel Discussion (Misc queries) | |||
Formula Error-Error Message | Excel Programming | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Formula error with Mac resulting in '#NAME' error | Excel Programming |