Using SUMIF across multiple worksheets

  • Thread starter Thread starter ssrai
  • Start date Start date
S

ssrai

Greetings,

I'm experiencing problems gettin the SUMIF formula to work whe
referincing multiple worksheets.

The basic formula i'm using to build the non-working formula is a
follows:

=SUMIF(A:A, "= 02 Feb",E:E)

Pretty standard stuff really: if colum A has the value of '0
Feb', add up the associated values which appear in colum E.


The following formula is also working:
=SUMIF(Midlands!A:A, "= 02 Feb",Midlands!E:E)

if colum A on another worksheet (in this case, the 'Midlands
worksheet) has the value of '02 Feb', add up the associated values
which appear in colum E and display within the worksheet which the
formula was entered on (i.e the South worksheet).


The following formula ISN'T working:
=SUMIF('Cable:Cambridge'!A:A, "= 02 Feb",'Cable:Cambridge'!E:E)

The cell is returning #VALUE! instead of the desired calculation


I've tried playing around with quote/exclamation marks but to n
avail.

Does anyone have a solution to this problem??
Any help would be greatly appreciated
 
Hi
SUMIF can only reference one sheet (does not support 3D references).
One workaround: Add SUMIFs for each worksheet
 
Back
Top