Forum Discussion
Viral TikTok expense tracker for excel and microsoft forms
Have you tried using semi-colons instead of commas in your formula? That's usually the case when working with Excel in non-English languages. Also, have you double-checked that the cell references are correct? It's easy to accidentally refer to the wrong cells and end up with errors. I checked out your expense sheet and it looks great! Good luck with your project. By the way, have you considered promoting your TikTok expense tracker on social media and https://iamat.com/buy-tiktok-likes/ to increase your reach? It could be a great way to share your work with others who might find it helpful!
JRuedaSamThe first thing that I see is that you have Google Sheet notation in your formula. Google Sheets uses the format A2:A to indicate start at A2 and use the rest of column A but Excel does NOT support that notation. I haven't looked at your attachment but you need to either define the range like A2:A100 or use the whole column A:A or define the range using a name or by formatting as Table (I recommend this) and use the table reference like Table1[columnName]
EDIT: So I found a few other errors in the formula including some basic format. I changed the semi-colons to commas (I'm in the USA) but also the format for the SUMIFS uses the conditional a value then the condition in a text format:
=SUMIFS(Expenses!$H$1:$H100, Expenses!$F$1:$F100, ">="&'Main Dashboard'!$A2, Expenses!$F$1:$F100, "<"&(EOMONTH('Main Dashboard'!$A2,0)+1), Expenses!$I$1:$I100, "="&'Main Dashboard'!B$1)so notice above how each of the comparators like >= and < are inside quotes and then concatenated with the value to be used. Note, this is the SAME as Google Sheets and the original Google Sheet formula did have it correctly formatted there.
see attached
Edit2: I updated the formula to use the Table notation:
=SUMIFS(Tabla1[Total Amount(Use ''.'' instead of '','' before decimals)], Tabla1[Purchase date], ">="&$A2, Tabla1[Purchase date], "<"&(EOMONTH($A2,0)+1), Tabla1[Category],"="&B$1)notice how the references to the "Expenses" tab now refer to the Tabla1 and the corresponding column name. It makes it a little more readable and will refer exactly to the table column size and note the entire column or miss data because you use F1:F100 but the data now goes to 200.
I attached EXPENSES-table to show that example
