You may want to look in the help index for SUMIF
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"touchngo" wrote in message
...
I want to make a price list for our salemen.
Ihave all the items and the optional items listed.
Now what I would like is be able to put a check mark beside the items and
have the total of all the items selected at the bottom.
Can this be done?