Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug-11-2014
post by Ragabones:
Count criteria in columns taking into account different criteria returning true or false
I'm trying to look at the value of 3 columns and tally a 1 or a 0 in a forth column based on if the have a 1 or a 0. 1 or a 0 represent true and false. This is easy using a simple countifs or the following.