Excel 2016: Formula Simplication

[ajay_gajree]

=IF(L90+M90>7,1,0)
+IF(L91+M91>7,1,0)
+IF(L92+M92>7,1,0)

I want to use a formula to count a range of a pair of cells if they are greater than 7 when added together

Possibly I wish to do this for 15 to 25 pairs of consecutive cells

Is there an easier way than adding a row as above for each row of cells?

Hope that is clear!

 

[JackDanIce]

Try:

=COUNTIF($L$90:$M$92,">"&7)

Adjust range to suit

 

[Peter_SSs]

Try (adjusting the ranges to suit)

=SUMPRODUCT(--(L90:L100+M90:M100>7))