Hello,
I am trying to use Google Sheets to create a budget tracker. I got the template from someone else and I'm trying to tweek it to fit my needs. How it is supposed to work is that I use a Google form to submit a response to sheet A and then sheet B has a formula to pull from sheet A to the right place. I believe there is something wrong with the formula that is being used but I don't know how to fix it.
The formula is: =SUMIFS(Expenses!$D$1:$D, Expenses!$B$1:$B, ">="&$A9, Expenses!$B$1:$B, "<"&(EOMONTH($A9, 0)+1), Expenses!$E$1:$E, "="&B$1)
I believe the problem lies within the first Expenses!$B$1:$B. When I highlighted it, it gave the date of 8/22/2020. So, when I input an expense using that date, it will calculate it. However, when I put in any other date, it won't register it. How can I fix this? I will try to post the link to the sheet below.
Bookmarks