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?
Are you aware that you asked the same thing here How To Add Cells Selected by Another Cell in the Row? and got an answer?
I thought I had asked and I went and looked in ‘followed’ but didn’t see it. So I asked again. I’m sorry about that. How can I fix it? I’m happy if a moderator deletes any or all.
Sorry about the question really. This was the answer which is good - but I thought I’d already tried that, which is bad, because it means I was just slack. ‘Thought I’d tried it.’ I probably tried the quotes around the tick but didn’t use semicolons, used commas instead.
It’s all my ineptitude. I’ll try get better. 
=SUMIF(A5:A20;"✔️";C5:C20)