Adding selected numbers
 

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?

Adding selected numbers
 

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?

Adding selected numbers
 

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


"Don Guillett" wrote:


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?

Adding selected numbers
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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


"Don Guillett" wrote:


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?

Adding selected numbers
 

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.

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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


"Don Guillett" wrote:


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?