How do I make a formula to total (sum) a column using Numbers on iOS, but exclude negative numbers? (Only sum positive numbers)


| LIST  |
|      1|
|      2|
|      3|
|      0|
|     -1|
|     -2|
|     -3|
|Total 6|

Basically, how can I calculate a total but ignoring negative numbers in the column?

  • Are you looking for a Sum total (0 wouldn’t matter anyway) or an Average total or what exactly? Would love to help if you could be a bit more precise. Cheers
    – bjbk
    Nov 20 '17 at 14:43
  • Just wanting a total but ignoring negative numbers in the column.
    – Sam
    Nov 20 '17 at 21:20

Summing a column with conditions can be done with the SUMIF() or SUMIFS functions.

The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 2000). To add numbers in a range based on multiple criteria, try the SUMIFS function.

For example:

=SUMIFS(A2:A10, A2:A10, “>0”)

Looks at all values greater than 0 and totals them up.

SUMIFS Function

To use formulas and functions in Numbers for iOS:

  • Select the cell in which you wish to have the calculation. (In the attached example, for instance, cell A11)
  • Type the equals sign character = or select circled equals sign icon.
  • Start typing the name of the function you wish to use, or tap the fx at the top left of the virtual keyboard to see a list of functions to choose from.

For more detailed information on how to use formulas and functions in Numbers for iOS, please see the official documentation here from Apple.

Enter a function in Numbers for iOS

Functions list

  • Thanks bjbk, but is SUMIFS available on iPad Numbers? I don't see it offered to me when I press the function button.
    – Sam
    Nov 21 '17 at 8:30
  • The screenshot attached is from iPad. In the cell first type an equal sign. Then type the function name. All functions are available. I’ll add more details to the answer for you.
    – bjbk
    Nov 21 '17 at 11:08
  • Thanks bjbk. Thanks for the example shots. They are what pointed me to 'categories' which was what I needed. I obviously don't know how to navigate my way around Numbers. Thanks again. I may be back with m next problem soon.
    – Sam
    Nov 22 '17 at 16:32
  • Glad it helped. If that answered your question please mark answered for the benefit of others.
    – bjbk
    Nov 22 '17 at 16:38
  • Sorry bkbk but I adjust looking how to do that but can't see it.
    – Sam
    Nov 22 '17 at 16:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .