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!
|