 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
So i'm doing some accounting... I'll simplify for simplicity!
I've table 1:
Column A - cost of item
Column B - 'type or expense' - from a dropdown of 5 predetermined 'types'.
I've table B:
Column E - Type of expense (5 rows, same as the dropdown list!)
Column F - [b]total SUM of this type of expense....[/b].
[b]Column F[/b] is what i'm struggling with. It would be the sum of the costs in Column A, who's 'type' (Column B) matches the 'type' in Column E..
SO that if I change an expense from, say "travel" to "professional fees" it'll update the "professional fees" SUM in Column F.....
Help much appreciated! What function/thing do I need? First one to help gets a free 'checkup' in the Swinley car park....
DrP
SUMIF function ?
Ooh, ta; i forgot that one - I'll see if it works!
DrP
iirc you can run a pivot table on table 1 to summarise the result by the expense type
Then you could just use the pivot table as table B
or if you wanted it in a different order then reference the particular total in the pivot table. That gives you a very fancy formula to paste in
Boom..allthepies..bend over and receive your prize.... you've got the one there!
SUMIF sorted it 🙂
DrP
😆
for once I'm happy I didn't get it right 🙂