Is there a way to pick the cells to add using sum?

[WTG]

I have two columns, one is descriptions and one is totals.
I want to add certian totals depending on the description.

ie....


A B
1 HL3 100
2 DLV 50
3 HL4 500
4 DLV 250

TOTAL DLV 300
TOTAL OF OTHERS 600

The DLV will always be the same, but the other descriptions will
change.

thanks for any help.

Wally

 

[Don Guillett]

Have a look in HELP index for SUMIF

 

[WTG]

Thanks,