software

I have the following grid excerpt:

WHSE Cost QtyTotalSales OH$$
H $28.57 86414583 $416,636.31 $24,684.48
H $5.13 742464566 $331,223.58 $38,085.12
H $98.28 1152833 $278,427.24 $11,302.20
E $14.76 105012000 $177,120.00 $15,498.00
H $65.06 1942194 $142,741.64 $12,621.64
H $12.20 7559567 $116,717.40 $9,211.00
E $14.76 9007050 $104,058.00 $13,284.00
H $189.17 43546 $103,286.82 $8,134.31
1 $46.90 2651921 $90,094.90 $12,428.50
H $12.20 4907234 $88,254.80 $5,978.00
1 $49.92 3201714 $85,562.88 $15,974.40
H $65.06 1911290 $83,927.40 $12,426.46
E $10.45 7007704 $80,506.80 $7,315.00
H $26.09 3932718 $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.

=SUMPRODUCT(--(A2:A200=quot;Hquot;),--(D2200gt;200000),D2200)

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Andrew Cquot; gt; wrote in message
...
gt; I have the following grid excerpt:
gt;
gt; WHSE Cost Qty Total Sales OH$$
gt; H $28.57 864 14583 $416,636.31 $24,684.48
gt; H $5.13 7424 64566 $331,223.58 $38,085.12
gt; H $98.28 115 2833 $278,427.24 $11,302.20
gt; E $14.76 1050 12000 $177,120.00 $15,498.00
gt; H $65.06 194 2194 $142,741.64 $12,621.64
gt; H $12.20 755 9567 $116,717.40 $9,211.00
gt; E $14.76 900 7050 $104,058.00 $13,284.00
gt; H $189.17 43 546 $103,286.82 $8,134.31
gt; 1 $46.90 265 1921 $90,094.90 $12,428.50
gt; H $12.20 490 7234 $88,254.80 $5,978.00
gt; 1 $49.92 320 1714 $85,562.88 $15,974.40
gt; H $65.06 191 1290 $83,927.40 $12,426.46
gt; E $10.45 700 7704 $80,506.80 $7,315.00
gt; H $26.09 393 2718 $70,912.62 $10,253.37
gt;
gt; I have been able to aggregate it using sumif and countif, however, I
cannot
gt; break it down by WHSE. I would like to count/sum the sales over $200,000
in
gt; a separate sheet/column by warehouse.