Apple’s Worldwide Developers Conference to kick off June 10 at 10 a.m. PDT with Keynote address
The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.
The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.
You can make a difference in the Apple Support Community!
When you sign up with your Apple ID, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple ID, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
A few common things could be occurring:
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.
A few common things could be occurring:
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.
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
