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,
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!
----
This link should allow you to share. - https://docs.google.com/
---------------------------------------------------------------------------
you may find my following solution to be of some interest
No comments:
Post a Comment