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!
Bookmarks