Budgeting forumla in Excel [Solved/Closed]

Posts
2
Registration date
Friday December 21, 2018
Status
Member
Last seen
December 22, 2018
-
Hi!

So I'm trying to write a budget for my household. Payments are made from different accounts.

I've included an example. If anything in Column A says "3333" I want the amount listed next to it in Column B to be included in the total of B7.

So 2 payments come out of "3333". The total of B2+B4 ...



System Configuration: iPhone / Chrome 71.0.3578.89
See more 

1 reply

Best answer
Posts
898
Registration date
Tuesday March 7, 2017
Status
Administrator
Last seen
December 4, 2019
1468
2
Thank you
Hello,

You need to use conditional formatting (SUMIF function) to correct the issue. In B7 enter:

=SUMIF(A2:A5,"3333",B2:B5)

You can see this Excel tip to learn more about the function.

Regards,
Daniel Telele

Community Manager and Social Media Editor - CCM.net

nfez
Posts
2
Registration date
Friday December 21, 2018
Status
Member
Last seen
December 22, 2018
-
Thanks!
Formatted the cell w/ "accounting" to get it to do exactly what I wanted (: