Google Spreadsheet Post #1891
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Feb-09-2015
post by Daniel Bru:
Sum VLOOKUP from many tables at once
https://docs.google.com/
Sum VLOOKUP from many tables at once
HI,
I am building a personal financial diary.
I have on the same sheet many different tables as shown in the attached picture.
https://docs.google.com/
Every little chart (like A4:B8) represents one day.
There will be 31 of those little charts (for every day in the month), all to the left of what you see on the picture (same rows).
I want to be able to count how much I spent on each entry, for example how much did I spend on transportation this month.
The best solution I came up with (after going through many forums) is:
doing SUM(VLOOKUP(*******),VLOOKUP(*
There must be a smarter way.
Please advise.
Hope I explained well :)
Thanks
---
Hello Yogi,
Thank you for your reply.
There it is:
In english this time :)
Please tell me if anything is still no clear.
Thank you again,
Daniel
------------------------------------------------------------------------------------------------------------------------
