ExcelBanter - ignore #n/a

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - ignore #n/a (https://www.excelbanter.com/excel-discussion-misc-queries/249354-ignore-n.html)

GENO

ignore #n/a

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

David Biddulph[_2_]

ignore #n/a

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

"GENO" wrote in message
...
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

Jacob Skaria

ignore #n/a

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

If this post helps click Yes
---------------
Jacob Skaria

"GENO" wrote:

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

All times are GMT +1. The time now is 04:00 AM.