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...
Thanks mate. As I added to the topic - it was kind of general BUG. I rebooted, rewrote formula absolutely identically and it worked.
My only guess if you had some non-printable character or wrong apostrophe sign within initial formula. Non-printable could appear if the formula copy/pasted from somewhere and partial editing didn't remove such character.