how tosum

[Rahul Mishra]

sir i have some data like this

12
13
#NAME?
#N/A
58
#NAME?

i want 83

 

[Deepak]

With CSE

{=SUM(IFERROR(A1:A6,0))}

 

[Rahul Mishra]

thanks sir
actually i forgot this formula

 

[Deepak]

Welcome!!

Don't forget to like if helped!!!

 

[Khalid NGO]

Another with CSE:
=SUM(IF(ISNUMBER(A1:A6),A1:A6,0))
Longer than Deepak

 

[bines53]

Another Without CSE

=AGGREGATE(9,6,A1:A6)

David

 

[prasaddn]

For some reason we (atleast me), tend to forget the usage of this beautiful "aggregate" functionality, may be it will get acquainted sooner and become frequently used formula.

Thank you for this solution!

Regards,
Prasad DN

 

[Deepak]

me too got it missed...