# Question about YTD Comparison Excel Spreadsheet **URL:** \ **Category:** Microsoft Excel\ **Tags:** excel, troubleshooting\ **Created:** [April 8, 2026, 7:38pm UTC](https://community.tiller.com/t/question-about-ytd-comparison-excel-spreadsheet/34483 "2026-04-08T19:38:10Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![mjcoleman0](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mjcoleman0/32/20127_2.png) [@mjcoleman0](https://community.tiller.com/u/mjcoleman0)\ **Post date:** [April 8, 2026, 7:38pm UTC](https://community.tiller.com/t/question-about-ytd-comparison-excel-spreadsheet/34483/1 "2026-04-08T19:38:10Z")
How is the YTD Net Budget formula calculated on the YTD Comparison Sheet. I have a formula warning on my sheet and not sure if I should be concerned. It appears to be just an inconsistent formula message ??? ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/5/4/5488f2925e08c76b1a2ef6185ac7d57ecd68089c.png) When I hover over the cell it states it “formula in the cell differs from the formulas in this area of the spreadsheet. It’s of those yellow triangle warning signs. Not sure if this is an issue or not. That’s why I am asking how this formula is calculated ?? thanks ---
**Author:** ![casilverthorn.96](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/casilverthorn.96/32/24067_2.png) [@casilverthorn.96](https://community.tiller.com/u/casilverthorn.96)\ **Post date:** [April 8, 2026, 10:23pm UTC](https://community.tiller.com/t/question-about-ytd-comparison-excel-spreadsheet/34483/2 "2026-04-08T22:23:20Z")
I am not familiar with this sheet, however, I have see errors like this in excel, and they are typically nothing to worry about. As an example A1, A2 and A4 might be a formula to sum, and A3 is a division. Excel sees that as an inconsistent formula, even though this might be intentional. If you see the expected amounts in the highlighted section, and you haven’t been updating formulas for your own purposes, then I would say it shouldn’t be a worry. ---
**Author:** ![mjcoleman0](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mjcoleman0/32/20127_2.png) [@mjcoleman0](https://community.tiller.com/u/mjcoleman0)\ **Post date:** [April 9, 2026, 8:11pm UTC](https://community.tiller.com/t/question-about-ytd-comparison-excel-spreadsheet/34483/3 "2026-04-09T20:11:31Z")
That’s what I thought. I am still in need of understanding how the Net YTD Budget number calculated if anyone else can explain how it is generated. Thanks ---
**Author:** ![twalane](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/twalane/32/16372_2.png) [@twalane](https://community.tiller.com/u/twalane)\ **Post date:** [April 15, 2026, 2:59am UTC](https://community.tiller.com/t/question-about-ytd-comparison-excel-spreadsheet/34483/4 "2026-04-15T02:59:56Z")
Hi @mjcoleman0 if you click into the number you should see a formula in the formula bar, likely figures in the hidden part of the sheet, but what’s considered should be total income budget numbers subtract expense budget (so based on what’s on your categories sheet). ---
**Author:** ![mjcoleman0](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mjcoleman0/32/20127_2.png) [@mjcoleman0](https://community.tiller.com/u/mjcoleman0)\ **Post date:** [April 15, 2026, 5:37pm UTC](https://community.tiller.com/t/question-about-ytd-comparison-excel-spreadsheet/34483/5 "2026-04-15T17:37:32Z")
I understand what you are saying but the only number that I am still struggling with how the YTD Net Net Budget is calculated. All other numbers and the formulas that sheet I can follow and understand the origins. If you could explain the calculation of the YTD Net Budget thaty would be great. thank you for your response ---
**Author:** ![casilverthorn.96](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/casilverthorn.96/32/24067_2.png) [@casilverthorn.96](https://community.tiller.com/u/casilverthorn.96)\ **Post date:** [April 15, 2026, 5:53pm UTC](https://community.tiller.com/t/question-about-ytd-comparison-excel-spreadsheet/34483/6 "2026-04-15T17:53:03Z")
```auto =SUMIFS(W2:W,U2:U,"Income",V2:V,"<>Hide")-SUMIFS(W2:W,U2:U,"Expense",V2:V,"<>Hide") ``` This is the formula in the sheets version of the ytd comparison sheet. If I am reading it right, it is taking the income type budget less hidden minus expense type less hidden. On mine, the net budget is 0 because I have a zero based budget. BUt in your case it looks like perhaps you have budgeted income of ~$500 more than you have budgeted expenses. If you check your sheet and the formula is different, can you post the formula here to see if I can figure it out. ---
**Author:** ![mjcoleman0](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mjcoleman0/32/20127_2.png) [@mjcoleman0](https://community.tiller.com/u/mjcoleman0)\ **Post date:** [April 15, 2026, 9:47pm UTC](https://community.tiller.com/t/question-about-ytd-comparison-excel-spreadsheet/34483/7 "2026-04-15T21:47:43Z")
This is the formula I have =IFERROR(SUMIFS(T2#,S2#,“Income”)-SUMIFS(T2#,S2#,“Expense”),“”) ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/3/e/3eeb9314c4e52595de822ea0f521cc93086e2570.png) ---
**Author:** ![casilverthorn.96](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/casilverthorn.96/32/24067_2.png) [@casilverthorn.96](https://community.tiller.com/u/casilverthorn.96)\ **Post date:** [April 15, 2026, 9:57pm UTC](https://community.tiller.com/t/question-about-ytd-comparison-excel-spreadsheet/34483/8 "2026-04-15T21:57:19Z")
It looks similar to the one in my sheet, so I think that is what it is doing: giving the difference between budgeted income and budgeted expense through date. Can you verify if the amount in ytd net budget is equal to the budgeted cash flow amount through date? If that is not what the formula is doing, can you tell me what column T and S are doing? ---
**Author:** ![mjcoleman0](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mjcoleman0/32/20127_2.png) [@mjcoleman0](https://community.tiller.com/u/mjcoleman0)\ **Post date:** [April 18, 2026, 8:12pm UTC](https://community.tiller.com/t/question-about-ytd-comparison-excel-spreadsheet/34483/9 "2026-04-18T20:12:35Z")
Bingo. It is the difference between budgeted income and budgeted expense. Thank you for your help on this Much appriciated