Thanks, I see your point and need to agree fully.
I tried to create a rather simple table, intending that the cells that have =SUM() display nothing if the adressed range has no input values. For this I chose the ISBLANK function. But the results I got puzzle me quite a lot.
The link is indeed to my OneDrive, I used the MS shortener, this is the long one:
https://onedrive.live.com/redir?resi...nt=file%2cxlsx
pic:
at H4, formula =ISBLANK(B3:B5) returns TRUE but at H6 =ISBLANK(B3:B5) returns FALSE. I cannot figure how to make it work.
My versions of Excel, both the full app and the online tool, are localized to Czech language. I suppose people with EN installation will see the formulas in English though.
FD.