Forum Discussion
Solved
SUMIF and COUNTIF don’t work in spreadsheets created through excel on iPad
Excel spreadsheets created on computer with SUMIF and COUNTIF formulas work perfectly. Creating a new spreadsheet on iPad and using these formulas don’t work, return zero. Is the excel app for iPad m...
willyak UPDATE: On your iOS device, goto Settings, General, Keyboard and turn off "Smart Punctuation". That stops defaulting to curly quotation marks.
willyak UPDATE: On your iOS device, goto Settings, General, Keyboard and turn off "Smart Punctuation". That stops defaulting to curly quotation marks.
- By turning off the smart punctuation as described on this thread - TOTALLY WORKS! Lifesaver. Thanks!
- Thank you for this! I had a coworker experience a problem where a formula worked on PC but not on iPad and this is why.
willyak You're welcome!
