I have a spreadsheet where each row has 3 checkboxes that need to be selected before I want the "no" (O7) to turn into a "yes". Essentially it's a "yes" instruction based on receiving check off from 3 different people in a group. I tried using the following formula, but it is only good for numbers and I can't figure out what might be a yes/no based formula.
=SUMIF(T7:V7,TRUE,W7:W7)
T7, U7, V7 = the true/false for the checkboxes
Thanks in advance!
For something like this you should use IF instead of SUMIF, but, I don't think you can use a formula with the checkboxes, you'd have to use VBA.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Hi,
Give this a try"
Cheers
=IF(COUNTIF(T7:V7,"False"),"No","Yes")
Amazing! Thank you so much!Originally Posted by southward
Hi,
Give this a try"
Cheers=IF(COUNTIF(T7:V7,"False"),"No","Yes")
If I wanted to educate myself, so I can figure things like this out myself, what is the best way to search the formulas and how to's in excel? I haven't had much luck with the more complicated things like this.
You are very welcome. Glad I could be of some assistance.
The way I have learned is mainly through searching and experimenting.
Cheers
Wow....why couldn't I get it to work on my mock-up sheet???
Here is my mock-up sheet.
Cheers
Ahhh haaa! I never new you could have the True/False value show in a linked cell like that. Now it all makes sense. Thanks southward!!
You are very welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks