SOLVED

# project budget

Copper Contributor

# project budget

Hello!

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)
Solution

# Re: project budget

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)

# Re: project budget

Thank you!
1 best response

Accepted Solutions
best response confirmed by Lualolga (Copper Contributor)
Solution

# Re: project budget

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)