Forum Discussion

4 Replies

  • NowshadAhmed's avatar
    NowshadAhmed
    Iron Contributor
    Jan 12, 2022
    You are using and IF function within a SUM function, which is causing this error. In your formula the function SUM is seeing your IF statement as another number to sum (which isn't).

    I see that you have a criteria for SUM. What you need here is SUMIF or SUMIFS.
    • geminiwwwww20's avatar
      geminiwwwww20
      Copper Contributor
      Jan 12, 2022
      Hi, I’m using =SUM(AA:BB) in the beginning but it showed #VALUE!
      So, I press the HELP button, it showed these solution ( refer to the picture above) but it not works.
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Jan 12, 2022

        geminiwwwww20 Note that your formula has three apostrophes ( ''' ),

        rather than the two quote marks ( "" ) as indicated in the help screen.

        That should fix it.

Resources