Formula's with #N/A's

Formula's with #N/A's

Post by Kevin McLe » Fri, 22 Aug 2003 04:31:17

I have some data that I would like to take the simple
average of "=Average(C2:C30)". The problem is there are
some #N/A's in the list. I am pretty sure there is a
formula that excludes #N/A's I just can't remember it.

I do realize that I can just replace the #N/A's with
zeros, but for other reasons I need the #N/A's to stay

Any ideas?

Thank you!

Formula's with #N/A's

Post by Bob Philli » Fri, 22 Aug 2003 04:39:29


=IF(ISNA(etc ...

or more generically



Bob Phillips
... looking out across Poole Harbour to the Purbecks


Formula's with #N/A's

Post by Laura Coo » Fri, 22 Aug 2003 04:40:00


This formula must be array entered - You must press ctrl+shift+enter (as
opposed to just hitting enter) after inserting the formula and subsequently
every time you edit the formula for it to work. If you do this correctly,
Excel will display the formula enclosed in curly braces {}.

Laura Cook
Appleton, WI

Formula's with #N/A's

Post by Aladin Aky » Fri, 22 Aug 2003 05:35:12