Help with Excel SUMIF Formula

[tomohawk]

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

[p45cal]

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

[tomohawk]

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

[Pecoflyer]

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

[tomohawk]

Thanks Pecoflyer

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

Tommy

[p45cal]

Originally Posted by tomohawk

Thanks Pecoflyer

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

Tommy

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

[Pecoflyer]

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