Forum Discussion
Solved
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, Unpla...
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)
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!