Counting columns whose sum is greater than a given number.

[Ingolf]

Hi,

In a spreadsheet, I have 2 rows and multiple columns (Say range A1: Z2). In every cell I have numbers from 0 to 9. I can not use rows / columns helpful. I need a formula to count, how many columns (A1 + A2, B1 + B2 ...) are the sum of numbers greater than 11.

 

[Mike LH]

Hi,

Try this

=SUMPRODUCT(--(A1:Z1+A2:Z2>11))

 

[iggydarsa]

=sumproduct(--((1:1)+(2:2)>11))

 

[Ingolf]

Thanks to both of you.