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?