What is wrong with this formula?
=COUNT(AND(I164="Monday",L164=1)+AND(I165="Monday",L165=1)+AND(I166="Monday",L166=1)+AND(I167="Monday",L167=1)+AND(I168="Monday",L168=1)+AND(I169="Monday",L169=1)+AND(I170="Monday",L170=1)+AND(I171="Monday",L171=1)+AND(I172="Monday",L172=1)+AND(I173="Monday",L173=1)+AND(I174="Monday",L174=1)+AND(I175="Monday",L175=1))
I am trying to add the number of times two variables in a row are true, in at least 12 rows.
Thanks.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]Just answered my own question.
=SUMIF(I164:I178,"Monday",L164:L178)