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
nfez Posts 2 Registration date Friday December 21, 2018 Status Member Last seen December 22, 2018 - Dec 22, 2018 at 11:02 AM
Related:
- Budgeting forumla in Excel
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel - Guide
- Screenshot in excel - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- How to enable vba in excel - Guide
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
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,
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,
Dec 22, 2018 at 11:02 AM
Formatted the cell w/ "accounting" to get it to do exactly what I wanted (: