sumif formula
 

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?

sumif formula
 

=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?

sumif formula
 

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?

sumif formula
 

try
=sumif(range,"10")-sumif(range,"=20")

"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?