Hi:

At first glance this question seems below this group's level , but it's
really not that simple, the list can go on and on and the items are numerous.


What would be the better way to sum the amounts Needed "Column E"
for the individual items in column A!.

A B C D E
1 Material Length Height SqFT Needed
2 Plywood 8 8 0.03 2
3 Block 4 2 1.13 9
4 Brick 10 10 6.75 675
5 Plywood 4 8 0.03 1
6 Block 4 12 1.13 54
7 Brick 10 12 6.75 810

Results Being:

Plywood 3
Block 63
Brick 1485


The result could be written to an obscure part of the worksheet
for the tally and reference if need be.

I tried to use some routines with dsum and subtotal but my solutions seemed
pretty clumsy.

Thanks