The SUMIF formula in first row of my table does not return a value. All other rows work correctly and return good values ? I’m a little unsure of formula structure or table setup. Thanks in advance….
[Edited by Moderator]
Original Title: Numbers on iOS issue
iPad Air 3, iPadOS 26
I was befuddled until your response. Then I checked the format of the pop up line listing “Hospital Invoices”. I had an extra space after Invoices! Once corrected the Hospital Invoices Summary table updated with values!!
Thank you Bad Unit for your quick response… I’m recovering in Italy from a bicycle accident in bed learning Numbers…. Working on this issue for 2 days!
I was befuddled until your response. Then I checked the format of the pop up line listing “Hospital Invoices”. I had an extra space after Invoices! Once corrected the Hospital Invoices Summary table updated with values!!
Thank you Bad Unit for your quick response… I’m recovering in Italy from a bicycle accident in bed learning Numbers…. Working on this issue for 2 days!
Assuming your formula is correct (I cannot see all of it or the Expenses table), one common problem is if the test value is not exactly the same as the condition. Make sure that "Hospital Invoices" is the same in both tables, that it is not "Hospital Invoice" in the Expenses table or "Hospital Invoices " (with a trailing space) in one table but not the other or something else different. Capitalization does not matter but everything else needs to be the same, including the spaces.
SUMIF formula not working in first row of Numbers table on iOS
