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...
Detlef_Lewin
Nov 21, 2023Silver Contributor
- maks_braverNov 21, 2023Copper ContributorIt's late here, I meant Sum, and the thing is not in TRUE;0 issue. Thanks for useless help 🙂