Why is formular working in some cells but not others?
I am using your "Annual Business Budget" template to which I added an 11th budget category, and a department column in the "Expense Intake & List" sheet. I am experiencing a problem with the Fixed and Variable expense formular not capturing the expense in the Budget and Tracking sheet.
=IF($Name@row <> "", (SUMIFS({Expense}, {Category}, $Name@row, {Period}, 1, {Type}, "Fixed")), "")
Best Answers
-
Ok. So it looks like some of your Categories don't match. For example, in one screenshot you have "8200 - Minor Equip" and in the other screenshot you have "8200 - Minor Equipment".
-
Happy to help. 👍️
Answers
-
Are you able to provide screenshots for context?
-
Here's the Expense intake.
And the Budget Tracking...8200 - Minor Equip, for example.
-
And the formular for Period 1...
=IF($Name@row <> "", (SUMIFS({Expense}, {Category}, $Name@row, {Period}, 1, {Type}, "Fixed")), "")
-
I can't see any of your column headers, so I am not sure where your formula is or what exactly each of the cross sheet references are pulling from.
-
Sorry about that!
Expense Intake...
Budget Tracking...
-
Ok. So it looks like some of your Categories don't match. For example, in one screenshot you have "8200 - Minor Equip" and in the other screenshot you have "8200 - Minor Equipment".
-
Details, details, details! I've been staring at it for so long. Thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!