Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
count based on multiple date criteria | Excel Worksheet Functions | |||
count cells using multiple criteria | Excel Discussion (Misc queries) | |||
Count using complex criteria | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |