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

Excel on mobile

Riny_van_Eekelen
Jan 31, 2021
willyak UPDATE: On your iOS device, goto Settings, General, Keyboard and turn off "Smart Punctuation". That stops defaulting to curly quotation marks.

Riny_van_Eekelen

Platinum Contributor

Jan 31, 2021

willyak UPDATE: On your iOS device, goto Settings, General, Keyboard and turn off "Smart Punctuation". That stops defaulting to curly quotation marks.