COUNT and SUM

an · Nov 8, 2005

Hello!

I have:
10
100
25
50
....

I would like SUM and COUNT all values >20, for example.

Thanks in advance.
an

Bob Phillips · Nov 8, 2005

=COUNTIF(A:A,">20")

=SUMIF(A:A,">20")

--

HTH

RP
(remove nothere from the email address if mailing direct)

an · Nov 8, 2005

Many thanks.
an

Bob Phillips said:
=COUNTIF(A:A,">20")

=SUMIF(A:A,">20")

--

HTH

RP
(remove nothere from the email address if mailing direct)