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