How to Build a Home Share Budget in Excel?

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 🙂


Best answer:

Answer by W

What do you think? Answer below!


  1. fathermartin121 says

    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.

Speak Your Mind