Results 1 to 4 of 4

Sum Product with Two Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Sum Product with Two Criteria

    HI. Can some please help me with the formula for the chart below.

    I need to sum the Dollar Sales of each brand in column A for multiple prices. Example: Brand A @ <$4, Between 4 and 6, Between 6 and 8, Betweem 8 and 10 and Greater than 10. I am fine with <4 but when I need to calc between multiple price points I continue to get an error.

    Brand Dollar Sales Unit Sales Price Category
    A $76,261 16,612 $4.69 Toys
    A $86,753 17,512 $4.97 Clothes
    B $76,735 16,655 $4.70 Paper
    B $6,710 645 $10.66 Paper
    D $10,103 1,001 $10.29 Toys
    C $21,019 2,234 $9.50 Toys
    F $206 56 $3.78 Clothes

    Thanks so much for the help!
    Attached Files Attached Files

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