With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, September 3, 2012
yogi_Consolidate Amounts By Categories From Monthly Data Sheets Into AnnualSummary Sheet
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).