SumIf across multiple worksheets

C

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?
 
D

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
 
Top