| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MULTIPLE (X3) COUNT IF FUNCTION
I have two tabs in a spreadsheet (DOG & CAT) and have the following function
set up to compare 3 questions, ie. only if all three equal the value required is the corresponding values counted. =COUNT(IF(DOG!J6:J1000=CAT!J7,IF(DIVA!S6:S1000=CAT !A12,IF(DOG!T6:T1000="0",DOG!B6:B1000,0)))) It's not working and returning strange amounts. It needs to look at the dog spreadsheet and compare the 3 different questions. How can I rearrange this to work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Double and Multiple Lookup Using the MATCH Function | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Sum and Count Function | Excel Worksheet Functions | |||
Threaded Mode
