| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i count values based on multiple criteria
i am using the formula in excel help
(=count(if((A2:A11="south")*(C2:C11="meat"),d2:d11 )) and adapting it to my needs, however, i do not understand the need for d2:d11 in the example and how it translates to my formula. I have been trying: =COUNT(IF(('[AltLnLog 2004.xls]Remington College Only'!S2:S6380="VV539")*('[AltLnLog 2004.xls]Remington College Only'!G2:G6380="Approved"),1,0)) but it always comes up with a total of 1 when i know there should be a total in the hundreds. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count of items using multiple criteria | Excel Worksheet Functions | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| Count Based upon Multiple Conditions | Excel Worksheet Functions | |||
| Can I count values in column 1 if criteria in column 2 are met | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
