Count or Sum based on more than 1 criteria
 

I have the following grid excerpt:

WHSE Cost Qty Total Sales OH$$
H $28.57 864 14583 $416,636.31 $24,684.48
H $5.13 7424 64566 $331,223.58 $38,085.12
H $98.28 115 2833 $278,427.24 $11,302.20
E $14.76 1050 12000 $177,120.00 $15,498.00
H $65.06 194 2194 $142,741.64 $12,621.64
H $12.20 755 9567 $116,717.40 $9,211.00
E $14.76 900 7050 $104,058.00 $13,284.00
H $189.17 43 546 $103,286.82 $8,134.31
1 $46.90 265 1921 $90,094.90 $12,428.50
H $12.20 490 7234 $88,254.80 $5,978.00
1 $49.92 320 1714 $85,562.88 $15,974.40
H $65.06 191 1290 $83,927.40 $12,426.46
E $10.45 700 7704 $80,506.80 $7,315.00
H $26.09 393 2718 $70,912.62 $10,253.37

I have been able to aggregate it using sumif and countif, however, I cannot
break it down by WHSE. I would like to count/sum the sales over $200,000 in
a separate sheet/column by warehouse.

Count or Sum based on more than 1 criteria
 

=SUMPRODUCT(--(A2:A200="H"),--(D2:D200200000),D2:D200)

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andrew C" wrote in message
...
I have the following grid excerpt:

WHSE Cost Qty Total Sales OH$$
H $28.57 864 14583 $416,636.31 $24,684.48
H $5.13 7424 64566 $331,223.58 $38,085.12
H $98.28 115 2833 $278,427.24 $11,302.20
E $14.76 1050 12000 $177,120.00 $15,498.00
H $65.06 194 2194 $142,741.64 $12,621.64
H $12.20 755 9567 $116,717.40 $9,211.00
E $14.76 900 7050 $104,058.00 $13,284.00
H $189.17 43 546 $103,286.82 $8,134.31
1 $46.90 265 1921 $90,094.90 $12,428.50
H $12.20 490 7234 $88,254.80 $5,978.00
1 $49.92 320 1714 $85,562.88 $15,974.40
H $65.06 191 1290 $83,927.40 $12,426.46
E $10.45 700 7704 $80,506.80 $7,315.00
H $26.09 393 2718 $70,912.62 $10,253.37

I have been able to aggregate it using sumif and countif, however, I
cannot
break it down by WHSE. I would like to count/sum the sales over $200,000
in
a separate sheet/column by warehouse.