Yes. I was assuming that the OP knew the difference between "na" and #N/A or NA().
--
David Biddulph

"Peo Sjoblom" wrote in message ...
True, but not error values if the OP had #N/A from for instance a VLOOKUP

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=SUM() will ignore any text values in the range.
--
David Biddulph

"jmcclain" wrote in message
...
How do I add a group of cells but ignore any cell with a value of "na"?

Thanks