Adding selected numbers

[touchngo]

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?

 

[Don Guillett]

You may want to look in the help index for SUMIF

 

[touchngo]

I must be missing something.
I want to add numbers in colum B if there is a check mark in colum A.

 

[Don Guillett]

OK. try this
=SUMPRODUCT((LEN(TRIM(a1:a21))>0)*b1:b21)

 

[touchngo]

Thanks that work perfect.

Would you know how to make a check mark show when I click on a cell and then
have it disapear again if I click again.