Forum Discussion
project budget
Hello!
Looking for any help please!
I am making a project budget spreadsheet with a list of expenditure, the expenditure has a column next to it with a categorisation e.g. Planned Misc, Unplanned misc.
Then i have a list at the top where i would like an automated total of the different categorisations so whenever i add a new expenditure and the category i dont need to then manually add the cell to the total if that makes sense.
Let's say the amounts are in D20 and down, and the categories in E20 and down.
You have a list of unique categories in A2:A15.
Enter the following formula in B2, then fill down to B15:
=SUMIF(E20:E10000, A2, D20:D10000)
2 Replies
Let's say the amounts are in D20 and down, and the categories in E20 and down.
You have a list of unique categories in A2:A15.
Enter the following formula in B2, then fill down to B15:
=SUMIF(E20:E10000, A2, D20:D10000)
- Thank you!
