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.

Hi Sean

If you want to count
=SUMPRODUCT((A2:A11="South")*(B2:B11="Meat"))

If you want to sum
=SUMPRODUCT((A2:A11="South")*(B2:B11="Meat")*C2:C1 1)

--
XL2002
Regards

William



"sean" wrote in message
...
| 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.

One way would be to Concatenate your two columns into a third helper column
and then just do a normal COUNTIF formula on it...........you could also do
Data Filter AutoFilter and select your items in your columns and
actually "see" just the rows you're interested in..........

Vaya con Dios,
Chuck, CABGx3

"sean" wrote in message
...
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.