| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding leading zeroes to selected alphanumeric cells | Excel Programming | |||
| Adding numbers or characters to existing numbers | Excel Worksheet Functions | |||
| Adding selected numbe in a column | New Users to Excel | |||
| Adding values for selected years | Excel Worksheet Functions | |||
| Adding selected cells | New Users to Excel | |||
Linear Mode
