Multiple Tabs, Totals of each elements

Hi,

Your YTD tab is blank(?). Are you not able to set up the results table in the form you would like it ready to be populated with formulas?

Also, your profile says 2003 yet you've attached an .xlsx - can you clarify?

Regards

This is a little complicated, but doable.

Go to Formulas -> Name Manager, hit New. Name a reference Sheets. Set it equal to ={"February 2014";"January 2014";"March 2014";"April 2014"}

Now on your YTD copy a list of unique row headers down A (I copied January over since it had the most)

B3: =SUMPRODUCT(SUMIFS(INDIRECT("'"&Sheets&"'!B3:B50"),INDIRECT("'"&Sheets&"'!A3:A50"),$A3))
C3: =SUMPRODUCT(SUMIFS(INDIRECT("'"&Sheets&"'!c3:c50"),INDIRECT("'"&Sheets&"'!A3:A50"),$A3))
D3: =SUMPRODUCT(SUMIFS(INDIRECT("'"&Sheets&"'!d3:d50"),INDIRECT("'"&Sheets&"'!A3:A50"),$A3))
E3: =SUMPRODUCT(SUMIFS(INDIRECT("'"&Sheets&"'!e3:e50"),INDIRECT("'"&Sheets&"'!A3:A50"),$A3))

And copy all 4 down

For future reference, this type of calculation is know as 3d.