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.
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.