Forum Discussion
geminiwwwww20
Jan 12, 2022Copper Contributor
Having this trouble when applying the sum formula
Does anyone can help me to solve this prob?
geminiwwwww20
Jan 12, 2022Copper Contributor
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.
So, I press the HELP button, it showed these solution ( refer to the picture above) but it not works.
Riny_van_Eekelen
Jan 12, 2022Platinum Contributor
geminiwwwww20 Note that your formula has three apostrophes ( ''' ),
rather than the two quote marks ( "" ) as indicated in the help screen.
That should fix it.