Microsoft Office Forums Help with Excel SUMIF Formula
 Register FAQ Search Today's Posts Mark Forums Read

#1
12-08-2023, 03:42 AM
 tomohawk Windows 10 Office 2019 Advanced Beginner Join Date: Sep 2020 Location: Dublin Posts: 48
Help with Excel SUMIF Formula

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
#2
12-08-2023, 08:50 AM
 p45cal Windows 10 Office 2021 Expert Join Date: Apr 2014 Posts: 855

Use straight double-quote marks (Shifted 2 in the keyboard).
You have and instead of "
#3
12-08-2023, 10:45 AM
 tomohawk Windows 10 Office 2019 Advanced Beginner Join Date: Sep 2020 Location: Dublin Posts: 48

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
#4
12-10-2023, 12:45 AM
 Pecoflyer Windows 10 Office 2021 Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,748

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
#5
12-10-2023, 03:26 AM
 tomohawk Windows 10 Office 2019 Advanced Beginner Join Date: Sep 2020 Location: Dublin Posts: 48

Thanks Pecoflyer

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

Tommy
#6
12-10-2023, 04:30 AM
 Pecoflyer Windows 10 Office 2021 Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,748

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
#7
12-10-2023, 05:35 AM
 p45cal Windows 10 Office 2021 Expert Join Date: Apr 2014 Posts: 855

Quote:
 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

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post ganesang Excel 8 09-05-2021 08:53 PM mwestra74 Excel Programming 10 11-28-2017 06:26 PM SLCREW Excel 5 02-22-2017 10:21 AM jcaswell Excel 3 05-22-2011 02:52 AM Todd Excel 9 02-27-2010 08:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:56 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top