days worked spreadsheet

[awhite1]

I need help creating a formula that will count two cells if they meet a criteria and have those two cells equal "1", not "1"per cell, 1 for both of the cells. and then equal zero if the criteria is not met. i am building a spread sheet that has 7 columns (one for each day of the week) then has a row under each day for straight time hours and one for overtime hours. i need to be able to count a day as "1" if it has any hours in either of the rows.


Mon Tues Wed Thur Fri Sat Sun
MOB 8 8 8 8 8 0 0
0 2 2 2 2 10 0



This would equal 5. I don't want to count Monday because it is a MOB day or Sunday because no hours were worked. Then i would like to apply this to multiple weeks. can any one help? I hope i gave enough information.

 

[Tetra201]

Try

=SUMPRODUCT(--(N(+A2:G2)+N(+A3:G3)>0))

 

[awhite1]

Thank you so much! it works perfect.