Forum Discussion
maks_braver
Nov 21, 2023Copper Contributor
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...
maks_braver
Nov 21, 2023Copper Contributor
SergeiBaklan thats what i'm saying. Thanks. I use sumifs all the time and it works properly, but somehow does not want to recognise ">"& construction and sugests it as a mistake. Thus sumif is ok with it 😞
SergeiBaklan
Nov 21, 2023MVP
Have no idea what it could be, especially if is formula works after the reboot. As workaround you may use
=SUMPRODUCT( $H$2:$H$300*($E$2:$E$300 > M2)*($E$2:$E$300 < M3) )
By the way, if change criteria places
=SUMIFS($H$2:$H$300, $E$2:$E$300,"<" & M3, $E$2:$E$300, ">" & M2)
it also gives an error?