SumIf across multiple worksheets
 

I am trying to use the following to summarize multiple worksheets:
=SUMIF(Best:Suverison!C3:C300,"Base",Best:Suveriso n!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?

SumIf across multiple worksheets
 

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
--
Brevity is the soul of wit.


"ChrisM" wrote:

I am trying to use the following to summarize multiple worksheets:
=SUMIF(Best:Suverison!C3:C300,"Base",Best:Suveriso n!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?

SumIf across multiple worksheets
 

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

Chris

"Dave F" wrote:

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
--
Brevity is the soul of wit.


"ChrisM" wrote:

I am trying to use the following to summarize multiple worksheets:
=SUMIF(Best:Suverison!C3:C300,"Base",Best:Suveriso n!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?

SumIf across multiple worksheets
 

Check this out:
http://help.lockergnome.com/office/S...ict867964.html

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

Dave
--
Brevity is the soul of wit.


"ChrisM" wrote:

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

Chris

"Dave F" wrote:

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
--
Brevity is the soul of wit.


"ChrisM" wrote:

I am trying to use the following to summarize multiple worksheets:
=SUMIF(Best:Suverison!C3:C300,"Base",Best:Suveriso n!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?

SumIf across multiple worksheets
 

Thank you Dave - I'll try that
Chris

"Dave F" wrote:

Check this out:
http://help.lockergnome.com/office/S...ict867964.html

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

Dave
--
Brevity is the soul of wit.


"ChrisM" wrote:

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

Chris

"Dave F" wrote:

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
--
Brevity is the soul of wit.


"ChrisM" wrote:

I am trying to use the following to summarize multiple worksheets:
=SUMIF(Best:Suverison!C3:C300,"Base",Best:Suveriso n!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?