COUNT and SUM

[Guest]

Hello!

I have:
10
100
25
50
....

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

Thanks in advance.
an

 

[Bob Phillips]

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

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

--

HTH

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

 

[Guest]

Many thanks.
an

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

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

--

HTH

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