Forum Discussion
SUMIFS date range general mistake
Good morning, In my excel I'm trying to sum data by date range: =SUMIFS($H$2:$H$300;$E$2:$E$300;">"&M2;$E$2:$E$300;"<"&M3) And get "You have mistake in your formula" with the whole line highlited...
The formula should have commas instead of semicolons, and the ranges and criteria should be properly paired.
=SUMIFS($H$2:$H$300, $E$2:$E$300, ">"&M2, $E$2:$E$300, "<"&M3)
Hope this will help you.
NikolinoDE thanks, but coma thing is regional isuue, we use ";" instead.
If you are still encountering issues, there might be a problem with the date format or some other regional setting affecting the formula.
Ensure that the date format in cells M2 and M3 matches the date format in the range $E$2:$E$300.
If there are discrepancies, Excel may have trouble interpreting the date criteria.
Also, make sure that the cell references and data in the specified ranges are accurate and free from any extra spaces or characters that might cause issues.
Thanks mate. As I added to the topic - it was kind of general BUG. I rebooted, rewrote formula absolutely identically and it worked.
