Excel formula

Kemik · 16 Nov 2008 at 16:35

Hey,

I'm looking for an Excel formula to go along with an IF statement. Basically I want to total the number of cells from A1 to A100 which contents a greater number than 50.

Any ideas?

Thanks.

Tomsk · 16 Nov 2008 at 16:59

SUMIF

Nanobot · 16 Nov 2008 at 17:39

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

Mattus · 16 Nov 2008 at 17:54

The way I read the question, you want to add up the number of cells, not the values of those cells. If so, you want COUNTIF rather than SUMIF.