ignore #n/a

G

GENO

Hi

I would like to ignore cells which reflect #n/a and consider cells with a
value from 0 .... , here is my current formula
"=SUM(I32:I53)/(COUNT(I32:I53)-COUNTIF(I32:I53,0)) "

i currently have a formula in cells i32:i53.

thanx
 
D

David Biddulph

=SUM(IF(ISNA(I32:I53),"",I32:I53))/(COUNT(I32:I53)-COUNTIF(I32:I53,0))
as an array formula (Control Shift Enter)
 
J

Jacob Skaria

Try
=SUMIF(I32:I53,"<>#N/A")/(COUNT(I32:I53)-COUNTIF(I32:I53,0))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Problem with Formula of IF/AND/COUNT/SUM 0
Formula R1C1 in VBA - Strange Results (Dynamic) 2
VBA Code to select and format range 2
#name? error message 5
Formula please 6
Cells to be mandatory fill have a formula in it 1
Run-time error 1004 with Range 4

Top