True, but not error values if the OP had #N/A from for instance a VLOOKUP


--


Regards,


Peo Sjoblom


"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