Is there a way to use a count if formula to calculate these for me. I have a lot of lines to do. What I need to add up the sums of column C for each item in column B. Example below
SumofCountIF.xls | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
1 | 32 | $ 99.54 | 32 | 120.76 | |||
2 | 32 | $ 7.72 | 28 | 81.06 | |||
3 | 32 | $ 13.50 | 6 | 81.06 | |||
4 | 198 | 116.18 | |||||
5 | 28 | $ 77.20 | |||||
6 | 28 | $ 3.86 | |||||
7 | |||||||
8 | 6 | $ 77.20 | |||||
9 | 6 | $ 3.86 | |||||
10 | |||||||
11 | 198 | $ 3.86 | |||||
12 | 198 | $ 27.00 | |||||
13 | 198 | $ 85.32 | |||||
Sheet1 |