project budget

[Lualolga]

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.

[#2 · Accepted solution]

@Lualolga 

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)

[#3]

Thank you!