Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wanting to check off items and have it add them to a total value
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
wanting to check off items and have it add them to a total val
Can you expand on your answer with more detail if you have the time?
Thank you! "akphidelt" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
wanting to check off items and have it add them to a total val
Alright first off there is 2 types of checkboxes. You want to go to
View-Toolbars-Forms Do not use the control Toolbox Checkbox On the checkbox from the Forms toolbox right click on it and go to "Format Control" There it will say something like "Cell Link". Click on the cell link box and then click on the cell you want the value to show up in. Now press ok, then go and click and unclick the checkbox, you will see a TRUE or FALSE when you click and unclick it. So now you can run formulas, such as if you put the cell links on the same row as the cost that you want to add up. You can have a formula that says something like =Sumif(Range,TRUE,SumRange) So every time you click a checkbox it will add the value up within that range, and everytime you uncheck it, it will not add up that value. "iaomonster" wrote: Can you expand on your answer with more detail if you have the time? Thank you! "akphidelt" wrote: 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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
wanting to check off items and have it add them to a total val
THANK YOU SO MUCH!
"akphidelt" wrote: Alright first off there is 2 types of checkboxes. You want to go to View-Toolbars-Forms Do not use the control Toolbox Checkbox On the checkbox from the Forms toolbox right click on it and go to "Format Control" There it will say something like "Cell Link". Click on the cell link box and then click on the cell you want the value to show up in. Now press ok, then go and click and unclick the checkbox, you will see a TRUE or FALSE when you click and unclick it. So now you can run formulas, such as if you put the cell links on the same row as the cost that you want to add up. You can have a formula that says something like =Sumif(Range,TRUE,SumRange) So every time you click a checkbox it will add the value up within that range, and everytime you uncheck it, it will not add up that value. "iaomonster" wrote: Can you expand on your answer with more detail if you have the time? Thank you! "akphidelt" wrote: 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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
wanting to check off items and have it add them to a total val
No problem!
"iaomonster" wrote: THANK YOU SO MUCH! "akphidelt" wrote: Alright first off there is 2 types of checkboxes. You want to go to View-Toolbars-Forms Do not use the control Toolbox Checkbox On the checkbox from the Forms toolbox right click on it and go to "Format Control" There it will say something like "Cell Link". Click on the cell link box and then click on the cell you want the value to show up in. Now press ok, then go and click and unclick the checkbox, you will see a TRUE or FALSE when you click and unclick it. So now you can run formulas, such as if you put the cell links on the same row as the cost that you want to add up. You can have a formula that says something like =Sumif(Range,TRUE,SumRange) So every time you click a checkbox it will add the value up within that range, and everytime you uncheck it, it will not add up that value. "iaomonster" wrote: Can you expand on your answer with more detail if you have the time? Thank you! "akphidelt" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check for duplicate items and delete them | Excel Discussion (Misc queries) | |||
Total Items Per Hour | Excel Discussion (Misc queries) | |||
How to total like items | Excel Discussion (Misc queries) | |||
check occurrence of items in a range | Excel Worksheet Functions | |||
check occurrence of items in a range | Excel Discussion (Misc queries) |