I need to TOTAL on sheet 2 the amounts on sheet 1, column b that are
H Harlan Grove Jul 25, 2007 #3 Rebecca1 said: I need to TOTAL on sheet 2 the amounts on sheet 1, column b that are >=250.00 and <1000.00. Click to expand... Simplest way, =SUMIF(Sheet2!B:B,">=250")-SUMIF(Sheet2!B:B,">=1000")
Rebecca1 said: I need to TOTAL on sheet 2 the amounts on sheet 1, column b that are >=250.00 and <1000.00. Click to expand... Simplest way, =SUMIF(Sheet2!B:B,">=250")-SUMIF(Sheet2!B:B,">=1000")
