for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

um Feb 2020 8:58am, 4 Feb 2020 1,689 posts	Quote Pin um Chris - don't understand how sum(h3:h9) can be different to h3+h4+h5+h6+h7+h8+h9 Please feel free to email me the sheet - or that section of it ( um-fetch@outlook.com ) if you want me to take a look
ChrisHB Feb 2020 12:16pm, 4 Feb 2020 18,814 posts	Quote Pin ChrisHB It's a libroffice one. I think I'll try in in google sheets. And maybe also destroy col H and enter the numbers again.
ChrisHB Feb 2020 12:02am, 6 Feb 2020 18,824 posts	Quote Pin ChrisHB I created column I as suggested as =Hn+0 And I put in a total =sum(I3:I369) and it gives the correct answer!
ChrisHB Feb 2020 6:10pm, 9 Feb 2020 18,839 posts	Quote Pin ChrisHB It was fine once I overwrote the numbers in H3-H9. Worrying, though. If most of the numbers hadn't been 1, I wouldn't have noticed.
flanker Feb 2020 6:41pm, 9 Feb 2020 18,959 posts	Quote Pin flanker sounds like you'd got some none-visible characters in with the "numbers"
Fizz :-) Feb 2020 2:40pm, 10 Feb 2020 3,522 posts	Quote Pin Fizz :-) My latest update gives me XLOOKUP.
icenutter Feb 2020 7:10pm, 10 Feb 2020 334 posts	Quote Pin icenutter Is that with office 365?
larkim Feb 2020 7:25pm, 10 Feb 2020 10,303 posts	Quote Pin larkim I just discovered =ifna(formula,"") after years of duplicating my outputs in =if(isna(formula),"",(formula)) I think there's iferror too. Much neater!
SPR Feb 2020 7:35pm, 10 Feb 2020 29,898 posts	Quote Pin SPR IFERROR has been around for awhile. Didn't know about IFNA though.
GlennR Feb 2020 8:27pm, 10 Feb 2020 47,516 posts	Quote Pin GlennR IFERROR() is a bit of a blunt instrument. IFNA() can be legitimately useful.