Monday, September 3, 2012

yogi_Consolidate Amounts By Categories From Monthly Data Sheets Into AnnualSummary Sheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #728   Sep 03, 2012     www.energyefficientbuild.com.

user jstrong10 said: (http://productforums.google.com/forum/?zx=nclx24r3fxl3#!mydiscussions/docs/LbbkQb94ki8)
How to add sumifs from multiple tabs
Hello,
I am trying to create a spreadsheet that will add up a certain criteria from multiple spreadsheets and total it. The formula I used for doing this for just one spreadsheet is the following: Category is for Cars =SUMIF('July Ledger (Daily)'!$C$5:$C$57,$A6,'July Ledger (Daily)'!$B$5:$B$57)
I then have this same formula pulled down over several different categories that I am tracking such as Parts, Employee Cost, etc. Where the "C" column is the category that I wish to be summed and the "B" column is the actual amount that is summed.
My efforts so far have been to create a range of the list of different Tabs/Spreadsheets that I am trying to add up, but have been unsuccessful. For example =SUMIF('July Ledger (Daily):December Ledger (Daily)'!$C$5:$C$57,$A6,'July Ledger (Daily):December Ledger (Daily)'!$B$5:$B$57). I then have Tabs/Spreadsheets labeled July Ledger (Daily) through December Ledger (Daily).
Thank you!
----
---------------------------------------------------------------------------
you may find my following solution to be of some interest