Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Budgeting forumla in Excel [Solved/Closed]

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

Answer 1 / 1
Posts
1264
Registration date
Tuesday March 7, 2017
Status
Member
Last seen
September 20, 2020
 3,559
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,
Thank you
2
Thank you

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

CCM 2942 users have said thank you to us this month

Report
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 (:
Ask a question