Tuesday, August 6, 2013

yogi_SetUp Formulas For Totals By Categories From Data In Another Sheet

                                          Google Spreadsheet   Post  #1319
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 7 2013
user  Lakedawgs (https://productforums.google.com/forum/#!mydiscussions/docs/f7-hf_gRdq0)
Need help with an excel file I have converted to Sheets, now has problems.
Hello,
Fairly competent with excel and Google Drive apps.
I have found an income/expense file for my homebrew beer club to use. Dropped it in to sheets and something went wrong with the 'Total Budget' page. It has something to do with ranges and pulling the numbers from the 'Income' and 'Expenses' pages. I have changed the Income and Expense categories to match my club and added a few new ones, don't know if this is part of the problem.
I am using this on a Win 7 machine at work and Win XP machine at home.

I am hoping one of the gurus here can look at this and boom boom, quick fix. I realize I am out of my depth.
I would happily take a suggestion of a similar template built for Sheets, but have not found one.

Here is the link to the Sheets file.

Very frustrated, any help is greatly appreciated.
Matt Anderson.
--------------------------------------------------------------------------------------------------------------------------------------------------