Excel SUM Function Not Working : Solve Sum Problem in Excel

Опубликовано: 12 Октябрь 2024
на канале: Zain Ali Tech
11,974
154

Why the SUM formula in Microsoft Excel doesn't work?. This short tutorial will give you a solution to the problem of the SUM formula not working.

Text instead of numbers: If the cells you are summing contain text instead of numbers, the SUM formula will not work correctly. Convert the text to numbers by using the VALUE function. For example, if your data is in cells A1 to A5, modify your formula to: =SUM(VALUE(A1:A5))
........................................................................
My Official Website: https://www.iamarsalan.com
My Amazon Store : https://www.amazon.com/shop/sirarsala...
Subscribe :    / @sirarsalanpctips  
My All Courses: https://www.youtube.com/@SirArsalanPc...
My Shorts : https://www.youtube.com/@SirArsalanPc...
.......................................
NOTE : All content used is copyright to Sir Arsalan - PcTips,
Use or commercial display or editing of the content without proper authorization is not allowed.