Forum Discussion
SUMIF and COUNTIF don’t work in spreadsheets created through excel on iPad
willyak UPDATE: On your iOS device, goto Settings, General, Keyboard and turn off "Smart Punctuation". That stops defaulting to curly quotation marks.
i’ve checked, all are numbers, it seams the “Y” is not being recognized. For example:
=SUMIF(d4:d25,”Y”,e4:e25)
This formula works on the excel version for the computer but not on the excel version for iPad. Further, if the spreadsheet is created on a computer with this formula and then I access the same file with the iPad, the formulas work. My problem, I work mainly on iPad and don’t readily have access to a computer.
willyak Not a frequent Excel Mobile user, but could test it on my iPhone. It seems that the keyboard on the mobile version defaults to italic (or curly) quotation marks, rather than straight ones. On the mobile keyboard, long-press or press and hold the quotation mark button. More options appear. Choose the straight quotation mark and your formula will work.
Don't ask me why the app defaults to a non-functional character. Couldn't find how to change this default behaviour and it doesn't seem to be related to language settings either. I have sent feed-back to MS via the mobile app as I think this is quite silly. Wait and see.