Thread: Sum by tool# help

You could try using SUMIF function

Code:

(A1)
Tool# .....January Qty
1234........1
2332........3
1234........5
2311........2
2332........1(B6)


Tool#.....January Tot Qty
(A9)1234.......=SUMIF($A$1:$B$6,A9,$B$1:$B$6)
2332.......=SUMIF($A$1:$B$6,A10,$B$1:$B$6)
2311.......=SUMIF($A$1:$B$6,A11,$B$1:$B$6)

Hope that helps.

pivot is your best bet, i guess without writing some serious vba you could use

=SUMIF

I.e

Create Fields for each of your groups,


Group name total
1234 =SUMIF(A1:A10,"1234",B1:B10)
2332 =SUMIF(A1:A10,"2332",B1:B10)

with the correct ranges, that is

It is correct that pivots are the best bet. If you set a pivot table's range to entire columns (like A:B for example) you can add new entires and refresh the pivot table. I believe you can even set the pivot table to refresh each time the file is opened.

You can do a similar thing with SUMIF() but a pivot table is less work IMHO.

Just my .02