Budgeting forumla in Excel [Solved/Closed]

Report
Posts
2
Registration date
Friday December 21, 2018
Status
Member
Last seen
December 22, 2018
-
nfez
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

1 reply

Posts
1023
Registration date
Tuesday March 7, 2017
Status
Administrator
Last seen
February 18, 2020
2,221
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4166 users have said thank you to us this month

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 (: