COUNT and SUM

Hello!

I have:
10
100
25
50
....

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

Thanks in advance.
an

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

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

--

HTH

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


"an" <an@discussions.microsoft.com> wrote in message
news:54E0E436-A5EC-44CA-BBCB-BFDEB8BBCE9D@microsoft.com...
> Hello!
>
> I have:
> 10
> 100
> 25
> 50
> ...
>
> I would like SUM and COUNT all values >20, for example.
>
> Thanks in advance.
> an

Many thanks.
an

"Bob Phillips" wrote:

> =COUNTIF(A:A,">20")
>
> =SUMIF(A:A,">20")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "an" <an@discussions.microsoft.com> wrote in message
> news:54E0E436-A5EC-44CA-BBCB-BFDEB8BBCE9D@microsoft.com...
> > Hello!
> >
> > I have:
> > 10
> > 100
> > 25
> > 50
> > ...
> >
> > I would like SUM and COUNT all values >20, for example.
> >
> > Thanks in advance.
> > an
>
>
>