I’m trying to enter a simple =sumif formula and keep getting the dreaded formula parse error or result is 0

Reading other responses, I did try replacing , with ; and still the same error

In trying to tally headcount if RSVP = Y, I’ve tried:

=sumif(A1:A30,Y,B1:B30) result is 0

=sumif(A1:A30,”Y”,B1:B30) result is formula parse error

=sumif(A1:A30;Y;B1:B30) result is 0 and when I check formula again, the ; are changed to ,

=sumif(A1:A30;”Y”;B1:B30) result is a formula parse error and the ; remain ,

I’ve formatted the responses column so Y is plain text and have also tried automatic formatting, no change in results.

I feel like I’m missing something obvious but unsure what. Would appreciate any guidance.

1 Answer 1


instead of ” ” you need to use " "

try: =SUMIF(A1:A30, "Y", B1:B30)

enter image description here

regarding American , vs. European ;...

you are using American version of syntax so all ; are auto-converted to ,

  • 1
    Thank you, that worked! I just enter quotes via keyboard on my iPhone and iPad. I had to copy your quote marks to get the formula to work. Any idea how to enter the appropriate quote marks directly? Thanks again!!
    – JCP
    Aug 16, 2018 at 3:19
  • @JCP i.stack.imgur.com/dYbAM.png (press and hold to bring up character selection)
    – user0
    Apr 9, 2019 at 12:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.