formula help the sequel
 

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.

formula help the sequel
 

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" wrote in message
...
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.

formula help the sequel
 

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....



"Mike" wrote in message
...
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.


.