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!