Hoffman
Board Regular
- Joined
- Oct 19, 2007
- Messages
- 222
- Office Version
- 365
- Platform
- MacOS
Sat 8-26-23
Hi EXCELent helpers,
I have this sort of unique need and have no idea where to begin. I'll briefly tell you what it's for and what I'm trying to achieve.
Thanks in advance for reading.
In Excel I have about 20 parts of my bike listed in Column A and in column B their weights in grams.
At the bottom of column B I have the total weight for all parts like normal.
However, I'd like to "turn off" or unclick some of these bike part entires in the list at times so I can see what the bike weighs without some things. So sometimes I want to see the wight at the bottom with all 20, other times, just 14 of them, sometimes 7 of them, etc
So for example
A B (grams)
bike light 40
wheels 1580
total grams = 1620
but I'd like to be able to see the total when I do NOT want the bike light weight or even able to ignore or turn off many items in the list.
Any creative ideas how to begin to do this would be appreciated!!!
Barry
Hi EXCELent helpers,
I have this sort of unique need and have no idea where to begin. I'll briefly tell you what it's for and what I'm trying to achieve.
Thanks in advance for reading.
In Excel I have about 20 parts of my bike listed in Column A and in column B their weights in grams.
At the bottom of column B I have the total weight for all parts like normal.
However, I'd like to "turn off" or unclick some of these bike part entires in the list at times so I can see what the bike weighs without some things. So sometimes I want to see the wight at the bottom with all 20, other times, just 14 of them, sometimes 7 of them, etc
So for example
A B (grams)
bike light 40
wheels 1580
total grams = 1620
but I'd like to be able to see the total when I do NOT want the bike light weight or even able to ignore or turn off many items in the list.
Any creative ideas how to begin to do this would be appreciated!!!
Barry