formula help the sequel

[Mike]

When asking cell A1 to give you the sum of A2:A10 is it
possible to ignore the cells in the range that contain
(#n/a.

 

[Daniel Klann]

Hi Mike,

Try using SUMIF e.g.

=SUMIF(A2:A10,"<>#N/A",A2:A10)

Hope this helps,
Daniel Klann
http://www.danielklann.com - goto the Excel section for a few useful
tricks....

 

[mike]

A 1,000 Thank yous Daniel, I'll give it a try.

-----Original Message-----
Hi Mike,

Try using SUMIF e.g.

=SUMIF(A2:A10,"<>#N/A",A2:A10)

Hope this helps,
Daniel Klann
http://www.danielklann.com - goto the Excel section for a few useful
tricks....






.