| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count the occurence of multiple (4 conditions). - Need urgent help
Hi,
I am unable to get the correct count using the formula : =SUM(IF(A1:A999=" A",IF(D1:D999="Dd",IF(F1:F999="1",IF(E1:E999="1", 1,0))))) I am trying to get no of records with " A" values in Column A, "Dd" values in Column D, "1" values in Column F, "1" values in Column E and Sum all the counts- after applying the nested filters. Can someone help me in debugging the same? Will appreciate early response! Thanks in advance, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| Count with multiple conditions | Excel Worksheet Functions | |||
| Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
| Count Based upon Multiple Conditions | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
