how do i count values based on multiple criteria

S

sean

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top