between 10 and 20 might be = 10 <=20 ??? depending on what is desired.
=SUMPRODUCT(--(A1:A10010),--(A1:A100<=20),A1:A100)

--
Don Guillett
SalesAid Software

"Teethless mama" wrote in message
...
=SUMPRODUCT(--(A1:A10010),--(A1:A100<20),A1:A100)


"alm09" wrote:

I need to calculate a total using a sumif function based of a range of
numbers. For instance, my criteria for the sumif needs to be "for any
cells
whose value is between 10 and 20". How would you write that formula?