Budgeting forumla in Excel [Solved/Closed]

Question

Previous Topic Next Topic

Budgeting forumla in Excel [Solved/Closed]

Report

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

Budgeting forumla in Excel
Excel Forumla help (IF formula) ✓ - Forum - Excel
Transfer data from one excel worksheet to another automatically - How-To - Excel
How to change date format in excel to dd/mm/yyyy - How-To - Excel
Excel @ in formula ✓ - Forum - Excel
Number to words in excel without vba ✓ - Forum - Excel

1 reply

Ask a question

Daniel Telele · Accepted Answer · 2018-12-22T07:04:45-0500

Answer 1 / 1

Daniel Telele

Posts: 1224
Registration date: Tuesday March 7, 2017
Status: Member
Last seen: May 16, 2021

5,754
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,

Report

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

Budgeting forumla in Excel [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!