COUNTIF and SUMIF question

[SSHO__99]

I have a column of various dollar amounts and I want to COUNT the number of
values between certain dollar amounts and then SUM the queried values. For
instance, I want to COUNT how many values there are between 0.00 and 4,999.99
and also SUM up what the total values are for that range of dollars. I
tried this formula:

=COUNTIF(A1:A220,">0.00 AND <5000.00")
=SUMIF(A1:A220,">0.00 AND <5000.00")

 

[Arvi Laanemets]

Hi

=COUNTIF(A1:A220,">0")-COUNTIF(A1:A220,"<5000")
or
=SUMPRODUCT(--(A1:A220>0),--(A1:A220<5000))

=SUMIF(A1:A220,">0")-SUMIF(A1:A220,"<5000")
or
=SUMPRODUCT(--(A1:A220>0),--(A1:A220<5000),A1:A220)

 

[Jason Morin]

Count:
=COUNTIF(A1:A10,">0")-COUNTIF(A1:A10,">=5000")

Sum:
=SUM(A1:A10,-SUMIF(A1:A10,{"<=0",">=5000"}))

HTH
Jason
Atlanta, GA