TM,

I'm trying to get your solution to work as it seems it will require less
data entry. Here is what I'm using...

=SUM(SUMIF(INDIRECT("Start:End!D4:D100"),D4,INDIRE CT("Start:End!B4:B100")))

=SUM(SUMIF(INDIRECT("Start:End!D4:D100"),D4,INDIRE CT("Start:End!C4:C100")))

My example was simplified, my criteria is actually in Column D with the
numbers I want to have summed up are in Columns B and C. I created a Start
and End worksheet and hid them as I figured that would be easier than
entering the 25 different worksheet values.

I get the dreated #REF error, so somehow I'm referencing some invalid data.

Any ideas where/how/what I'm doing wrong?

THANKS!

"Teethless mama" wrote:

In Summary sheet:

Criteria start in C1

In A1:
=SUM(SUMIF(INDIRECT("Sheet"&{1,2,3}&"!C1:C100"),C1 ,INDIRECT("Sheet"&{1,2,3}&"!a1:a100")))

In B1:
=SUM(SUMIF(INDIRECT("Sheet"&{1,2,3}&"!C1:C100"),C1 ,INDIRECT("Sheet"&{1,2,3}&"!b1:b100")))

Select A1 & B1 copy down