I have my data in a sheet named "Current"



I am trying to write a formula in a separate sheet that will sum values in column D based on 2 criteria in column G

I am getting a #NAME? error (for Criteria)when I click (fx) into the formula . The result in the cell is shown as zero.

Here is the formula.
=SUMIF(Current!G:G,“Tommy”,Current!D)+SUMIF(Curr ent!G:G,“Pauline”,Current!D)

Thanks,
Tommy

Use straight double-quote marks (Shifted 2 in the keyboard).
You have “ and ” instead of "

Thanks a million p45cal

Believe it or not, I had copied the formula originally from a response to my question in Bing Copilot.

Humans beat AI this time

Also be aware that " : D " without the space makes it an emoji on the board

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks Pecoflyer

I did realise the emoji, but inserting a space would have invalidated the formula.

Tommy

I find that referencing entire columns is bad practice. Using structured tables is much better IMO

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

You can disable smilies; if you're not already in 'advanced' view when composing a reply/question, you can click Go Advanced then towards the bottom you have:
2023-12-10_123136.jpg


Alternatively, you can wrap your formula in code tags:
2023-12-10_123711.jpg