User Profile
maks_braver
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
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 E range and M2, M3 cells are Date. Besides SUMIF - works perfectly with the same syntaxis: =SUMIF($E$2:$E$300;">"&M2;$H$2:$H$300) The question - Why? SOLVED! Some kind of a bug. After reboot it works.1.7KViews0likes11Comments
Groups
Recent Blog Articles
No content to show