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