Question by Alex: How to build a home share budget in Excel?
I am trying to build a home share budget in excel, so far It’s basically a table with:
What is due / How much / Is it Paid?/ By who?/How to build a home share budget in Excel?
There is 4 of us living together, so i would like to have a piece of code that returns a sum of everything someone paid (i.e. looks for occurrences of the name in column 4 and adds up values from column 2). Can this be done, and how?
Thanks a lot for your help 🙂
Alex.
Best answer:
Answer by W
Vlookups.
What do you think? Answer below!
=Sumif(Column4,name,column2)
I suggest you list the four name is a summary area and put this formula next to it and the name is replaced by the cell reference, then copy it down. Be sure to make the column reference absolute.