Array Elements Added Up

[JWGoldfinch]

I'm pretty sure this will require an array formula, but here goes. I have a table of 3 columns and 50 Rows in each column, all cells have numeric values, I need to add up all the values in the table if the value in each cell is greater than a given value, example is greater than "50".

 

[Eric W]

Maybe:

=SUMIF(A1:C50,">50")

 

[JWGoldfinch]

Thanks Eric, I would have thought it would have required an array formula, but just think of all the time I wasted !!!!

 

[Eric W]

Array formulas can do some cool things, but regular functions sometimes have unknown useful features. And if you learned something, the time wasn't entirely wasted!

Glad I could help!