Excel Master banoge hi!😎, 99% log is SUM problem ko galat solve karte hain… sahi method yeh hai 🔥

Описание: (SUM Not Working Because of “KG”)

Excel me SUM formula kaam nahi karta jab numbers ke saath “KG” ya koi text laga hota hai. Is video me main dikhata hoon ki Ctrl + H se ‘KG’ ko quickly remove karke, phir Ctrl + 1 se cell format me KG add karne ke baad SUM instantly kaam karta hai. Ye trick daily sales, stock, UOM data aur quantity reports me sabse fast solution hai. Beginners bhi 10 seconds me ye problem solve kar paayenge.

In this video:

SUM formula not working fix

Text + Number problem solution

Ctrl + H cleaning trick

Ctrl + 1 custom format method

Instant SUM calculation

Excel sales data cleaning hack


Channel: Advance Excel Person
Daily Excel shortcuts, automation tricks & pro formulas 🔥