Excel Array: Get Sum of digits (without VBA)
HTML-код
- Опубликовано: 8 сен 2024
- Hello Friends,
In this video you will learn how to get SUM of digits in excel without using of VBA. I have used combination of SUMPRODUCT, MID, INDIRECT, ROW and LEN function together.
Please download this excel file from below given link:
drive.google.c...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Facebook:
/ pkan-excel-expert-9748...
Telegram:
t.me/joinchat/...
blogger:
pk-anexcelexper...
Twitter:
/ priyendra_kumar
Send me your queries on telegram:
@PKanExcelExpert
Thank you 👍😊
Most welcome
Thank you so much really helpful
Glad it helped
thanks soo much sir it helped alot
Thank you very much dude.
Thanks for your valuable feedback
Excelente trabajo. Felicitaciones, gracias por su aporte.
Gracias por ver.
Gracisa asadafa
Nice trick.
Demo video using Logical and string formula in excel. Waiting....
Nicely explained, I have one query
If I want to total only 1st 2digit like 4+5 and again required separately 3digit like 5+4+5
from one cell, can you explain any formula please?
Nice Solution!!!
I have a query related to this issue. How to use LENGTH (LEN) function in Conditional Formating? I need to show RED colour in respective cell, if the length of the characters inserted in the cell more than 5 or less than 5?
Thank you in advance.
Sir agr sum ke jgh difference chaiye to kon sa formula lgega
like this same way i want to multiply (instead of sum) the digits in same cell
could u plz tell the formula for that
Hi PK, could you make a video about the formula to extract the letter and number from a cell. Example: AB303 to AB and 303, A288B to AB and 288.
Sure, I will definitely try to make such video very soon.
I have copied this formula in my excel sheet but it is not working in my excel sheet.
whatwill change yadi maanon735.50 paise hai aur total sirf 735 ka chaahiye decimal ke baad ki digit ka nahi only 735
Koi vba ka use karwa do😂
Koi function automatically wale banva do😂😂
Koi template banva do😂😂😂
Koi function defined karwa do😂
Koi auto correct✔✔✅✔☑ ka use karwa do😂
Excel ka koi vedic math 📐📊📚version nahin hain kya😅😅😅
Koi single defined functions nahin hain kya😅😅😅😅
Itni musibaton ka koi hal nahin hain kya😅😅😅
Good day how about numbers up to 6 to 8 digits like 100+456.78+25999+456.23+.75 this is for our inventory i try that formula but only for single digits hope to respond thank you.
If I have a decimal number then how sum digit