Menu
Ask a question Report

Budgeting forumla in Excel [Solved/Closed]

Posts
2
Registration date
Friday December 21, 2018
Last seen
December 22, 2018
 -
Excel Ask a question Report
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
Report Respond to Daniel Telele
Posts
532
Registration date
Tuesday March 7, 2017
Status
Verified expert
Last seen
January 19, 2019
 356
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

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