SUMIF Issue

Try removing the pound symbol from the entries for B4 thru B8 (if you typed it in) format as currency instead using the cell formatter.

You may also want to consider a checkbox for the paid column:

Often this happens when the "numbers" to be summed up are not actually numeric. Are the cells in B4:B8 formatted as currency? If you copy/pasted them in from somewhere else, the Pound sign on the left will be text, rendering the entire number as text and they won't sum.

Michael,

Numbers is NOT excel so you should not expect it to behave exactly the same. That being said for things like this it are very similar. I would not recomment typing the currency symbol in ANY spreadsheet. Instead I would enter the value, then format the number as needed.

I am hypothesizing that Excel sees the currency symbol (in your case the pound symbol) and formats the cell as currency.

Currency and checkboxes are both formatting options. I do not have Numbers on an iOS device so I will demonstrat on Numbers for Mac OS and you should then poke around for the same items:

select the cell(s) in this example they are B4 thru B9:

Now open the cell formatter and change the format from "automatic" to "currency", then select the currency type from the "Currency" pop-up menu. Notice that "Checkbox" is near the end of this popup menu

Numbers will migrate that formatting forward to cells that use those values:

Hi Michael,

If you haven't already, recommend you have a look at the Personal Budget template included with Numbers for iOS. It is a good example of how to use SUMIF. You can work from there by adding a Paid column with checkboxes and perhaps using SUMIFS.

SG

If we are comparing Excel to Numbers, the comparison has to be against the Mac version, not the iPad version of Numbers. On the Mac version of Numbers (3.1), you can type the currency symbol and a number and it will format the cell as currency. On the iPad version it is more particular about how you enter the data. To type the £ symbol yourself, you first had to press the "T" to format the cell as text then used the "£" on the keyboard. The result is a cell formatted as text. If you instead start with the "42" button and then use the currency buttton, it will format the cell as currency. I believe you can convert all of your existing cells to this format without having to retype anything. Select the cells or the entire column then use the paintbrush (format button) to format them as currency.

You are awesome. Thanks for your help. it works!!