+ Reply to Thread
Results 1 to 2 of 2

Count or Sum based on more than 1 criteria

Hybrid View

  1. #1
    Andrew C
    Guest

    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. #2
    Bob Phillips
    Guest

    Re: Count or Sum based on more than 1 criteria

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

    etc.

    --

    HTH

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


    "Andrew C" <AndrewC@discussions.microsoft.com> wrote in message
    news:6E12BC75-204C-44D2-BB96-5F2DD261C1D7@microsoft.com...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1