View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default wanting to check off items and have it add them to a total value

Yes it is. For each check box you will have to right click on it and assign
its cell link to a cell on the screen. So each time you check and uncheck it
that cell changes value.

Then to sum up the total you would use a Sumif formula basically summing any
cost where the checkbox value is -1 or whatever the checkbox value is when
checked.

"iao monster" wrote:

Hello,
I would greatly appreciate any help with this issue.

I have data that is comprised of items which each have their own cost. Is
it possible to click a checkbox next to each of these items and have it tally
the total at the bottom for just the items that are checked off?

Thank you in advance!