Forum Discussion
Solved
Sumifs return incorrect result
Hi Tech Community I wonder if you can help me? I have a spreadsheet which uses sumifs, but it seems that the results returned are not always correct. I am not sure how to attach the sprea...
- I'm guessing you didn't enter it as forced text (either '1-1 or into cells pre-formatted as text) and therefore Excel assumed those to be dates and in the case of 1-1 that is Jan 1 (this yr) and in the case of 1-23 it is Jan 2023 (and assumed the 1st) and hence BOTH 1-1 and 1-23 resulted in 2023-01-01 as the date value and hence the same value. but that is just my guess. In the other cases the Month-Day (of this year) and the Month-Year values didn't overlap so there wasn't an issue.
The formula for the cell in question is
=SUMIFS(Table2[Width],Table2[Plot],$B386,Table2[Head],$D$384)
I reduced the table by using the resizing handle in the right hand lower corner.
It is not a filter but defines the size of the table.
