Forum Discussion
Solved
Nested IF formula column’s SUM problem
Hi there , I have a column with Nested IF formula and I need to sum of column and sum is showing 00:00 with SUM formula. Can anyone solve this error
You use "10:00" in your formula. That is text. And SUM() ignores text.
Either convert with TIMEVALUE() or double-negative or use TIME() or 10/24.
You use "10:00" in your formula. That is text. And SUM() ignores text.
Either convert with TIMEVALUE() or double-negative or use TIME() or 10/24.
Detlef_Lewin yes, this has been worked , but SUM still not working if I select them sum shows on bottom .
- It’s worked. Thanks 🙏
