how do i count values based on multiple criteria

[Guest]

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.

 

[William]

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:C11)

--
XL2002
Regards

William

(e-mail address removed)

| 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.

 

[CLR]

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