On the last example, you can also reverse it by using False as the criteria, and it will add up all the ones that's are not checked. I used this when calculating an average from a dataset, but wanted specific ones to not be included because of special circumstances
@@ExcelUI recently enrolled in Excel University. And Im REALLY ENJOYING your classes. I’ve already learned some things and Im only classified as a Freshman at Excel University. Awesome stuff! Cant wait to sit in on your bonus live sessions. I like how the games reinforce what I’ve learned too. And of course the homework is very helpful!
@@tommyhodges Amazing!!! I sincerely appreciate your kind note, and am thrilled you are enjoying the classes so far. Freshman year is a bit of the foundations and then things take a really fun turn Sophomore year :) Looking forward to catching up with you during office hours!!
Insert the checkbox as described then enter a formula like =F3>4 in the same cell as the Checkbox (adjusting the formula for whatever you want to test). If the answer to your if query is true the Checkbox is ticked. You could apply multiple queries by using =IFS( F3>4,G3>6) - multiplying single queries together like =(F3>4)*(G3>6), which technically should give the correct result, seems to destroy the formatting of the Checkbox. Good luck
So simple when you know how. Great explanation. thanks Paul
Your chuckle after explaining exercise 3 CRACKED ME UP!!!! I love your sense of humor.
Thank you 😂
On the last example, you can also reverse it by using False as the criteria, and it will add up all the ones that's are not checked. I used this when calculating an average from a dataset, but wanted specific ones to not be included because of special circumstances
What is it about this checkbox feature that poses a security risk? This is the reason my POB gave for disallowing its use.
VEry well explained.
And I thought I was the only person who made a spreadsheet to calculate how many Battle Stars I needed to get stuff.
glad it's not just me 🤣
@@ExcelUI recently enrolled in Excel University. And Im REALLY ENJOYING your classes. I’ve already learned some things and Im only classified as a Freshman at Excel University. Awesome stuff! Cant wait to sit in on your bonus live sessions. I like how the games reinforce what I’ve learned too. And of course the homework is very helpful!
@@tommyhodges Amazing!!! I sincerely appreciate your kind note, and am thrilled you are enjoying the classes so far. Freshman year is a bit of the foundations and then things take a really fun turn Sophomore year :)
Looking forward to catching up with you during office hours!!
When I open my Insert tab I don't have the option for a Checkbox. I don't even have the Controls section there. Any idea what is going on?
Right click anywhere on the ribbon and choose customize ribbon. Check the Developer box. Now go to the Developer Tab to insert a checkbox.
It will depend on which version of Excel you have, I think Checkboxes are only available in 365 & the online version.
Excellent explanation! What if I need it to be the other way around? I mean, the checkbox get self-checked based on the value of another cell.
Insert the checkbox as described then enter a formula like =F3>4 in the same cell as the Checkbox (adjusting the formula for whatever you want to test). If the answer to your if query is true the Checkbox is ticked.
You could apply multiple queries by using =IFS( F3>4,G3>6) - multiplying single queries together like =(F3>4)*(G3>6), which technically should give the correct result, seems to destroy the formatting of the Checkbox. Good luck