Forum Discussion

maks_braver's avatar
maks_braver
Copper Contributor
Nov 21, 2023

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...
Excel
Formulas and Functions
office 365
  • maks_braver's avatar
    maks_braver
    Copper Contributor
    Nov 21, 2023
    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's avatar
      SergeiBaklan
      MVP
      Nov 21, 2023

      maks_braver 

      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?