project budget

Copper Contributor



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.

2 Replies
best response confirmed by Lualolga (Copper Contributor)



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!