Using SUMIF across multiple worksheets

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
 
F

Frank Kabel

Hi
SUMIF can only reference one sheet (does not support 3D references).
One workaround: Add SUMIFs for each worksheet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM 2 Conditions 3
date from multiple worksheets 3
Using SUMIF Function to get data from several worksheets 3
sumif for multiple columns 1
Sumif range? 2
Summing over multiple worksheets 1
Problem with Sumif formula 5
Sumif using Arrays 2

Top