how to Use the LARGE function in Excel || sum large in excel

MS Excel: Large Formula - Hindi, if you calculate small value then use the small function as well as, Quick Find List Of Large Numbers & Sum in Excel IN Hindi - With Large Formula, Excel - Small and Large functions Introduction

#largeformula #msexcel #sumlarge
channel
My second channel
Like us on:-
Follow us on:-

Prectice File Download Link:-

Video Link:-
Invoice 1
Invoice 2 Fully Automated
Invoice 3 Backup Button
Day Book
Data Validation

Advanced Filter-1
Advanced Filter-2
Macro in Excel
Fill Series:-
How to hide and protect formula in excel
Index+Match
Data Consolidate Multyple sheets
Stock Maintain Part-1
Conditional Formatting
Sumif and Sumifs
Data Consolidate

stock maintain part 2
Stock maintain part 3
match
piovet table Slicer
insert timeline
if
piovet table

[dr.atultiwari]

I am facing a strange problem. In Sum & Large (Nested) formula,
Here is the process I did-
I typed some figures (5, 7, 3, 9, 0, 0) in cell row (C5 to C11).
Now I used "IF" formula in cell row C15 to C20 instructing that if Cells C5 to C11 Contains a number that is more than 1 then put ".5" in cells C15 to C20 else display 0.
It worked well & I got desired number (.5) in desired row (C15 to C20).

Now problem began
In Cell C21, I put SUM +LARGE formula together instructing to display "SUM of top 4 numbers from selected cell rows C15 to C20". They all carry same number / figure (.5).
But it shows a "Number_Error"?

I thought that formula (SUM+LARGE) is not recognizing digits contained in C15 to C20 (.5) as number because there were not typed there but appeared through "If" formula.

To confirm that I used only "SUM" formula by selecting cells (C15 to C20). I thought when formula (SUM + Large) is not recognizing ".5" contained in row (C15 to C20) as number then "Sum Function" will also not recognize it as a number & will not give me total of it (C15 to C20).

But I was stunned when SUM formula gave me the correct result!

That means- digits of (.5) are well recognized correctly by formula but nested formula (SUME + LARGE) is showing "Number_Error". I have given up so seeking you for help.

Another probability is- nested formula (SUM + LARGE) doesn't work for a row? but only for column or whole array? I don't know.
Being expert in field only you can deal with this.
Please help & Oblige
Thanks
Dr. Atul Tiwari (MD)