SUMIF and 3D Referencing

**youradhere4222** · 03-28-2012, 06:53 PM

I'm doing a school project with Excel. Essentially, I have a sheet for each season (Summer through Spring) and an annual sheet. I need to count up the quantity of values in the rows of other sheets if it meets a certain criteria, and then put it into the final sheet.

So I need SUMIF and 3D Cell Referencing.

Anyway, here is the equation I derived:

=SUMIF(Fall_Ads:Summer_Ads!B4:B18,"Magazine",Fall_Ads:Summer_Ads!F4:F18)

It's returning a #VALUE error though. Is there anything wrong with my syntax? (And yes, F4:F18 are in the number format).

**DGagnon** · 03-28-2012, 07:00 PM

i dont think you can reference a range of sheets, you will need to do 4 SUMIFs and add them together, one for each season.

**Haseeb Avarakkan** · 03-28-2012, 07:09 PM

Or..

Enter all sheet names in a range, eg; D1:D2, then you can use

=SUMPRODUCT(SUMIF(INDIRECT("'"&$D$1:$D$2&"'!B:B"),"Magazine",INDIRECT("'"&$D$1:$D$2&"'!F:F")))

SUMIF and 3D Referencing

LinkBack

Thread Tools

Rate This Thread

Display

SUMIF and 3D Referencing

Re: SUMIF and 3D Referencing

Re: SUMIF and 3D Referencing

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions