#1
|
|||
|
|||
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
|
||||
|
||||
Use straight double-quote marks (Shifted 2 in the keyboard).
You have “ and ” instead of " |
#3
|
|||
|
|||
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
|
||||
|
||||
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
|
|||
|
|||
Thanks Pecoflyer
I did realise the emoji, but inserting a space would have invalidated the formula. Tommy |
#6
|
||||
|
||||
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
|
||||
|
||||
Quote:
2023-12-10_123136.jpg Alternatively, you can wrap your formula in code tags: 2023-12-10_123711.jpg |
|
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 |
SUMIF Formula question | jcaswell | Excel | 3 | 05-22-2011 02:52 AM |
Need Help With SUMIF Formula In R1C1 Style | Todd | Excel | 9 | 02-27-2010 08:30 PM |