May 22 2019 04:42 AM
I an using Excel 2016 on Win 10 Plaltform.
I am having problems with adding Cells in Two Columns ( H34 +G54) to another Cell.
Both Cells are Formatted as Number.
Using either (=H34+G54) or =SUM(H34,G54) or =SUM(H34:G54) all return Zero (0.00)
I cannot identify the cause of this.
Can someone shed some light on what I might be doing wrong.
May 22 2019 06:03 AM
@Nasho23 , most probably you have texts in your cells, even if number format is applied. You may check from any empty cell by =ISTEXT(H34)
May 22 2019 10:05 AM