What is the correct syntax for Sumif when condition is for a text string?

Hi ishiiboy

I can't reproduce your problem. It works for me (Columns changed to make a smaller screen shot):

Formula in C2 is:

=SUMIF(A2:A10, "=Grc", B2:B10)

Column A formatted as Text.

Column B formatted as Number.

Column C formatted as Automatic.

Regards,

Ian.

P.S. I have had an Aha! moment. Are you entering "Grc" with those quotes?

Just enter Grc.

Ian.

Ishi,

Make this change and I believe you will have success:

=SUMIF(B, E, C)

Jerry

This forum is for Numbers on a Mac running OS X. Is you screen shot from an iOS device?

I don't know anything about Numbers for iOS.

Or are you using Excel?

Just a guess, but try removing the quotes around =Grc in the formula.

If you are running iOS, you will get a better answer in this forum:

https://discussions.apple.com/community/app_store/iwork_for_ios?view=discussions

Regards,

Ian.

Hi ishii,

Your screen shots make no sense to me. I am using Numbers'09 on a MacBook Pro running OS X. Please tell us what device, operating system and app you are using. You still have not told us.

This forum is for Numbers on a Mac running OS X. Is your screen shot from an iOS device?

I don't know anything about Numbers for iOS.

Or are you using Excel?

I can not help you. If you are using an iPad, you will get a better answer in this forum:

https://discussions.apple.com/community/app_store/iwork_for_ios?view=discussions

Regards,

Ian.

ishiiboy wrote:

Hi Jerrold Green1,

I tried it, but it forces the column letters into a string literal with quotation marks and still gives me a "0".

Don't type the column references, click on the column tab to enter the reference.

Jerry

I regret that I can't confirm your problem. I reluctantly retrieved my iPod and fired up my iOS Numbers to test this problem. Since the iPod has such a compact user interface, I can only show you a portion of the expression in the editor, but I think you can determine that the function is working as I suggested it would.

I'm sorry that I can't bring myself to exactly duplicate your layout since it grates on me to have Header Rows and Columns and not use them.

I so dislike the iOS Numbers app on the iPhone/iPod platform that I rarely use it. Those times that I do use it, it's with great gnashing of teeth as I fumble with what to me is an awkward interface. Ultimately though, a simple example like this can be demonstrated.

I'd like to help you, but beyond resturcturing the solution so as to not use quoted text within the expression, I can't thing of anything else to suggest. There's not much else to look at.

Jerry

The problem is column C has text "numbers", not actual numbers. You can tell because they are left justified like text, not right justified like numbers. Select C2 and click the "42" icon instead of the "T" and it will become a number and will sum up in the SUMIF. Do the same for the rest of the column.

ishiiboy,

Have you read Badunit's diagnosis? I'm sure he has hit on the answer.

Jerry