Forum Discussion
SUMIFS function not working with date range
I am attempting to calculate debits from a ledger within monthly date ranges. However, I am only getting a "0" as a result. As far as I can tell, I am doing everything correctly. I have formatted all...
=NUMBERVALUE([@Date])
=SUMIFS(Table3[WD],Table3[Spalte1],">="&B3,Table3[Spalte1],"<="&C3)
I added a new column to Table3 with the number value of column date and applied the above SUMIFS formula and it works in my spreadsheet.