Budgeting forumla in Excel

Solved/Closed
nfez Posts 2 Registration date Friday December 21, 2018 Status Member Last seen December 22, 2018 - Updated on Dec 22, 2018 at 07:00 AM
nfez Posts 2 Registration date Friday December 21, 2018 Status Member Last seen December 22, 2018 - Dec 22, 2018 at 11:02 AM
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

1 reply

Daniel Telele Posts 1227 Registration date Tuesday March 7, 2017 Status Member Last seen November 4, 2021 6,277
Dec 22, 2018 at 07:04 AM
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,
2
nfez Posts 2 Registration date Friday December 21, 2018 Status Member Last seen December 22, 2018
Dec 22, 2018 at 11:02 AM
Thanks!
Formatted the cell w/ "accounting" to get it to do exactly what I wanted (:
0