Jul 12 2021 06:35 AM
Jul 12 2021 06:53 AM
@hassimyunus1gmailcom wrote: ``Please advise why should this be "0"``.
One reason might be your bad habit of putting quotes around numbers. Zero is 0, not "0".
The amounts that you are SUMing might be text, not numeric. Use formulas of the form =ISTEXT(A1) to confirm (or disprove) that A1 is indeed text. Looks can be deceiving; and the format of the cell does not matter.
If they are indeed text and you cannot figure out why, attach an example Excel file that demonstrates the problem. There are many possible reasons.