# Calculating a custom total for a column on iPad mini and Numbers

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

Example:

``````+-------+
| 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. ### 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.  • 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