#NA error

Giganews Newsgroups
Subject: #NA error
Posted by:  Mark R
Date: Mon, 13 Aug 2007

Hi,

i am auto summing on a range of cells. soome of the cells do not have
figures in yet but do have formulas that return #NA at the moment.

How do I ignore those cells until they have data in and only count the cells
with figures

i.e
1
1
#N/A
#N/A
#N/A
#N/A

Replies