I am trying to use the sumif() function but I can’t get it to work with the tick character.
So I’m trying to do something like =sumif(a5:a20,,c5:c20) (got that tick from emojipedia)
And I just get an error - 500 something I think - and it truncates the command to the first comma.
Is it not possible?