If 'X" sum

[BPWagner]

I am working on a budget spreadsheet with over 200 account numbers in 12 different departments. I would like to get a total of charges to each of those separate account numbers. I am hopeful that there would be some type of IF statement that will prevent me from going through the process of sorting over 500 rows.

150010 T ECONOMY BOND PAPER 136.32
150010 T MATTE BLACK INK 13 143.96
150010 T BLACK INK 130ML 71.98
150010 T CYAN INK 130ML 71.98
150010 T MAGENTA INK 130ML 71.98
150010 T YELLOW INK 130ML 71.98
150162 T POSTER PRO DESIGN 475.00
151188 WH12615 232.59
151188 WH12615 126.47
152305 T MATTE BLACK INK 13 287.92
152305 T CYAN INK 130ML 71.98
152305 T MAGENTA INK 130ML 71.98
152305 T YELLOW INK 130ML 71.98

[ragavan.sridar1]

Did you use "Subtotal function"?

[Pete_UK]

Use SUMIF. Put 150010 in E1 (and other codes below it), then put this formula in F1:

=SUMIF(A:A,E1,C:C)

then copy down.

Hope this helps.

Pete

[Kevin UK]

Hi BPWagne

You could also use a pivot table.