Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2023, 03:42 AM
tomohawk tomohawk is offline Help with Excel SUMIF Formula Windows 10 Help with Excel SUMIF Formula Office 2019
Advanced Beginner
Help with Excel SUMIF Formula
 
Join Date: Sep 2020
Location: Dublin
Posts: 48
tomohawk is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 12-08-2023, 08:50 AM
p45cal's Avatar
p45cal p45cal is offline Help with Excel SUMIF Formula Windows 10 Help with Excel SUMIF Formula Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Use straight double-quote marks (Shifted 2 in the keyboard).
You have and instead of "
Reply With Quote
  #3  
Old 12-08-2023, 10:45 AM
tomohawk tomohawk is offline Help with Excel SUMIF Formula Windows 10 Help with Excel SUMIF Formula Office 2019
Advanced Beginner
Help with Excel SUMIF Formula
 
Join Date: Sep 2020
Location: Dublin
Posts: 48
tomohawk is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 12-10-2023, 12:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with Excel SUMIF Formula Windows 10 Help with Excel SUMIF Formula Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,748
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #5  
Old 12-10-2023, 03:26 AM
tomohawk tomohawk is offline Help with Excel SUMIF Formula Windows 10 Help with Excel SUMIF Formula Office 2019
Advanced Beginner
Help with Excel SUMIF Formula
 
Join Date: Sep 2020
Location: Dublin
Posts: 48
tomohawk is on a distinguished road
Default

Thanks Pecoflyer

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

Tommy
Reply With Quote
  #6  
Old 12-10-2023, 04:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help with Excel SUMIF Formula Windows 10 Help with Excel SUMIF Formula Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,748
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #7  
Old 12-10-2023, 05:35 AM
p45cal's Avatar
p45cal p45cal is offline Help with Excel SUMIF Formula Windows 10 Help with Excel SUMIF Formula Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by tomohawk View Post
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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel function sumif help ganesang Excel 8 09-05-2021 08:53 PM
Data connection problem excel/sharepoint using an SUMIF array mwestra74 Excel Programming 10 11-28-2017 06:26 PM
Using SUMIF when criteria is a formula SLCREW Excel 5 02-22-2017 10:21 AM
Help with Excel SUMIF Formula SUMIF Formula question jcaswell Excel 3 05-22-2011 02:52 AM
Help with Excel SUMIF Formula Need Help With SUMIF Formula In R1C1 Style Todd Excel 9 02-27-2010 08:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft