SUMIF - how between two numbers

  • Thread starter Thread starter Paul Lengyel
  • Start date Start date
P

Paul Lengyel

Greetings,

I want to SUMIF if the value of cells are between 5000
and 10000?

Note: I am not summing anything. I have already SUM a
colum. But for the next phase of my project, I have used
SUMIF. If it is under 5000, it is displayed in a cell.
I then take that sum and use it elsewhere. If it is
between 5000 and 10000, I need to have it displayed in
that cell and then it will be used in a different
functuon elsewhere.

I know that if I want to add amounts under 5000 it would
be: =SUMIF(I10,"<5000.00",I10) but what is the symbol
or word and way to write "between" two amounts.

In normal type, it would be "5000-1000" how is it in
EXCEL language

TIA
-Paul
 
Paul,

Try
=SUMPRODUCT((A1:A100>=5000)*(A1:A100<=10000),(A1:A1000))

change range to suit, and you may want > 5000 and < 10000.



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top