Error in SUMIFS across multiple tabs

**mavericky10** · 01-05-2015, 02:08 PM

Hi,
I am using 2 tabs in excel sheet.
Tab 1 name: ConsolidatedData
Tab 2 name: Answer

For a cell in tab 2 to display sum based on 2 conditions in tab 1, I am using the below formula which is returning 0 as the answer.
=SUMIFS(ConsolidatedData!G2:G178932,ConsolidatedData!H2:H178932,"2011",ConsolidatedData!AJ:AJ178932,"<=2")

In tab 1, column G values I want to sum up. Column H has year values 2011, 2012 and 2013. Column AJ has risk values rated from 1 to 5.

Can anyone tell me if there is anything wrong with the formula?

**mcmahobt** · 01-05-2015, 04:15 PM

You are missing the column reference in the last criteria range for your formula:

=SUMIFS(ConsolidatedData!G2:G178932,ConsolidatedData!H2:H178932,"2011",ConsolidatedData!AJ2:AJ178932,"<=2")

That is what you will need (I believe).

Hope this helps!

Error in SUMIFS across multiple tabs

LinkBack

Thread Tools

Rate This Thread

Display

Error in SUMIFS across multiple tabs

Re: Error in SUMIFS across multiple tabs

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] summing multiple sub-tabs where each sub tabs row data is not the same

I have a spreadsheet with multiple tabs. I need one of those tabs uploaded to outlook cal

SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result

Copying values from multiple Tabs of a WB into corresponding Tabs of another WB using VBA

Macro to select multiple worksheet tabs based on color of the tabs

Bookmarks

Bookmarks

Posting Permissions