SumIf across multiple worksheets

[ChrisM]

I am trying to use the following to summarize multiple worksheets:
=SUMIF(Best:Suverison!C3:C300,"Base",Best:Suverison!K3:K300) and I am
receiving #VALUE! The values contained in the sum_range K3:K300 are results
of formulas within the individual worksheets - can anyone help?

 

[Dave F]

Something in your formula doesn't look right. Why are you using a colon, as
in Best:Suverison ?

Typically formulas across sheets have a format like =H13+'Sheet1'!F10 , etc.

Dave

 

[ChrisM]

I am using the colon for a range of worksheets within the workbook.

Chris

 

[Dave F]

Check this out:
http://help.lockergnome.com/office/SUMIF-multiple-ftopict867964.html

Scroll to the bottom. SUMPRODUCT seems to work for what you're looking to do.

Dave

 

[ChrisM]

Thank you Dave - I'll try that
Chris

Check this out:
http://help.lockergnome.com/office/SUMIF-multiple-ftopict867964.html

Scroll to the bottom. SUMPRODUCT seems to work for what you're looking to do.

Dave