You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers Formula SUMIF

The formula for SUMIF isn't working on the last row of my table. I've made sure it's not a footer table. The total keeps up coming up as 0. I've tried adding another row underneath but that also comes out as 0.

Any ideas please?

Thank you

MacBook Air 11″, macOS 11.2

Posted on Apr 28, 2021 10:19 AM

Reply
Question marked as Top-ranking reply

Posted on Apr 28, 2021 12:51 PM

A few common things could be occurring:

  1. The formula is incorrect. The ranges could be mixed up, the condition might be written incorrectly, or something else. It is hard to tell from here.
  2. The formula is not finding any matches and therefore nothing is being summed or the sum is actually zero. I.e., it is working properly and the sum is actually zero. Given you are posting it as a problem, this is unlikely.
  3. The values to be summed are formatted as text, not a numeric format (or automatic). Numbers that are formatted as text will be ignored, just like all other text is ignored in SUM, SUMIF, etc.


A screenshot and your formula could help determine if the formula is correct. For the third one, select all the cells you are trying to sum and take a look at the cell format to see if they are text. If they are "text" or "automatic", change them to a numeric format, select a cell somewhere else, then select them all again and see if the format stuck.

Similar questions

2 replies
Question marked as Top-ranking reply

Apr 28, 2021 12:51 PM in response to camille-marie112

A few common things could be occurring:

  1. The formula is incorrect. The ranges could be mixed up, the condition might be written incorrectly, or something else. It is hard to tell from here.
  2. The formula is not finding any matches and therefore nothing is being summed or the sum is actually zero. I.e., it is working properly and the sum is actually zero. Given you are posting it as a problem, this is unlikely.
  3. The values to be summed are formatted as text, not a numeric format (or automatic). Numbers that are formatted as text will be ignored, just like all other text is ignored in SUM, SUMIF, etc.


A screenshot and your formula could help determine if the formula is correct. For the third one, select all the cells you are trying to sum and take a look at the cell format to see if they are text. If they are "text" or "automatic", change them to a numeric format, select a cell somewhere else, then select them all again and see if the format stuck.

Apr 28, 2021 11:15 AM in response to camille-marie112

Hi Camille-Marie,


Can you show us your current formula and a screen shot of the table showing the column(s) involved in the calculation?


Double slick the cell containing the formula to open the editor.


Place the pointer just above and to the left of the circle at the intersection of the column and row reference tabs.

Press shift - command - 4

Drag the pointer down and right until the selection rectangle includes the columns that are highlighted in the colours seen in the formula, then release the mouse button to capture the image.


To include the image in your post here, click the 'two mountains' button (second last in the row of buttons below the message you are writing), then double-clck the image file ("Screen Shot " followed by the date and time). The image will appear in your post after a short pause.


More specific information will lead to a quicker answer.


Regards,

Barry

Numbers Formula SUMIF

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.