Basically, I want the most efficient way to do something like the following in the most efficient way possible and with a lot more columns:
=and(f2=true,g2=true,h2=true,i2=true)
Thank you.
Basically, I want the most efficient way to do something like the following in the most efficient way possible and with a lot more columns:
Thank you. 


You can do this very concisely with an array formula. Paste the following into the formula bar and press Ctrl+Shift+Enter.
EDIT:
This should also be entered as an array function by pressing Ctrl+Shift+Enter. If by chance you want to count both



You could do something like this for shorter:
This counts the number of Or if you don't want to 'count' them and put the number...
The above will not take into consideration blank cells. If you want to count them too:



Another option is to use the fact that TRUE evaluates to 1 and FALSE evaluates to 0 in certain circumstances. Description of TRUE and FALSE evaluation Using the link above you could use the function
which would evaluate to 1 if they are all true and 0 if there are any falses or blanks. this function need to be entered by pressing ctrl+shift+enter as it's an array formula. 

