I'm using Excel for the accounting purposes of a group venture, to keep track of our expenses, costs, payments, and balances.
- Details of each expense are stored in columns
- Total costs and balances are stored in columns
- Payments and dates are stored in columns
Generally speaking, I'm responsible for 34% of the cost of most expenses, whereas each other party is responsible for 22% of the cost of most expenses. This is the case for the majority of expenses.
However, there are a few expenses that I would like to split only between specific parties –
J10 – which are emphasized by a green, bold font in the screenshot above.
Understanding the parties column:
1111(me, alex, nan, nate)
- et cetera
I'm not sure how to go about this, therefore I have a few questions:
Is there a formula to ignore certain values in a row based on other values in the same row? For example, is there a way for the collective total cost formula,
=SUM(H:H), to ignore
H10, other than something like
Conversely, is there a formula to select every value in the
Hcolumn whose value in the
Jcolumn is equal to