Excel Array: Get Sum of digits (without VBA)

Показать описание

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:

Watch the best info-graphics and dynamic charts from below link:

Facebook:

Telegram:

blogger:

Twitter:

Send me your queries on telegram:
@PKanExcelExpert

Рекомендации по теме

Комментарии

Excelente trabajo. Felicitaciones, gracias por su aporte.

Angexcel

Nice trick.
Demo video using Logical and string formula in excel. Waiting....

Rajesh-njlw

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?

santtoshthavvi

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.

jamimanusrat

Sir agr sum ke jgh difference chaiye to kon sa formula lgega

upanshu

like this same way i want to multiply (instead of sum) the digits in same cell

could u plz tell the formula for that

pranamshriyan

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.

Sambath

whatwill change yadi maanon735.50 paise hai aur total sirf 735 ka chaahiye decimal ke baad ki digit ka nahi only 735

aman

I have copied this formula in my excel sheet but it is not working in my excel sheet.

manishshakya

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😂

anilkumarsharma

Excel ka koi vedic math 📐📊📚version nahin hain kya😅😅😅

anilkumarsharma

Koi single defined functions nahin hain kya😅😅😅😅
Itni musibaton ka koi hal nahin hain kya😅😅😅

anilkumarsharma

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.

romelellivera

If I have a decimal number then how sum digit

F

Excel Array: Get Sum of digits (without VBA)

Excel Array: Get Sum of digits (without VBA)

How to Use Arrays to SUM Data in Excel

Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)

Excel Dynamic Arrays (How they will change EVERYTHING!)

Excel Formula to Sum All Digits: Old School Dynamic Array Formula? Excel Magic Trick 1609

Excel: Sum Across Multiple Columns With One or More Criteria - 3 Methods

Using SUMIFS with arrays | Excel problem... Solved! | Excel Off The Grid

How to Count Rows with OR condition with Excel Array Formula - SUMPRODUCT & FREQUENCY (Part 1/3)

R course full tutorials 6 hours

How to count unique values Excel

Excel Magic Trick 1462: 5,000 Formulas in a Single Cell with SUMPRODUCT or Array Formula?

XLOOKUP Sum of All Matches Using Excel | XLOOKUP or SUMIF? | XLOOKUP or SUMPRODUCT?

How to Sum a Column or Row of Excel Cells

Find numbers in sum [Excel Solver]

How to Use SUMPRODUCT in Excel

How to use the SUMIF function in Microsoft Excel

Excel - Sum Product Array function

How to use VLOOKUP with SUM in excel | VLOOKUP with '*' | Excel Magic

Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

How to SUMIFS With Multiple Criteria In the SAME Column in Excel

How to Sum Values If a Cell Contains a Specific Text | SKYXCEL

Excel Dynamic YTD Calculations: OFFSET, SUMPRODUCT & SUM

VLOOKUP | Sum ALL Matching Values Or Sum ENTIRE MATCHING ROW or COLUMN

Sum the Top 5 Values - Excel Formula