How do I calculate the frequency for a set of numbers which includes #NA
error ie ignore the error

Thanks

The following worked for me:
=FREQUENCY(A1:A25*NOT(ISERROR(A1:A25)),B1:B25*NOT( ISERROR(B1:B25))

Let me know if it doesn't work for you.

"Saintsman" wrote:

How do I calculate the frequency for a set of numbers which includes #NA
error ie ignore the error

Thanks

Forget this reply. It worked for me because I didn't recalculate and I was
in manual calculation mode. So, actually, it didn't work at all.

"~L" wrote:

The following worked for me:
=FREQUENCY(A1:A25*NOT(ISERROR(A1:A25)),B1:B25*NOT( ISERROR(B1:B25))

Let me know if it doesn't work for you.

"Saintsman" wrote:

How do I calculate the frequency for a set of numbers which includes #NA
error ie ignore the error

Thanks

=FREQUENCY(IF(NOT(ISNA(A1:A25)),A1:A25,0),IF(NOT(I SNA(B1:B25)),B1:B25,0)

Array entered using Control + Shift + Enter.

I'm going for coffee.

"~L" wrote:

Forget this reply. It worked for me because I didn't recalculate and I was
in manual calculation mode. So, actually, it didn't work at all.

"~L" wrote:

The following worked for me:
=FREQUENCY(A1:A25*NOT(ISERROR(A1:A25)),B1:B25*NOT( ISERROR(B1:B25))

Let me know if it doesn't work for you.

"Saintsman" wrote:

How do I calculate the frequency for a set of numbers which includes #NA
error ie ignore the error

Thanks

Hi,

You didn't tell us the formula you are using for frequency, so

If you are using COUNTIF then

=COUNTIF(A$1:A$9,C1)

No array needed and no check for the NA.

If you are using FREQUENCY thent ry the following array entered formula:

=FREQUENCY(IF(ISNA(A1:A9),"",A1:A9),C1:C4)

Where A1:A9 is your data, C1:C4 is your bin range.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Saintsman" wrote:

How do I calculate the frequency for a set of numbers which includes #NA
error ie ignore the error

Thanks

Thanks very much - that gave me what I needed

"Shane Devenshire" wrote:

Hi,

You didn't tell us the formula you are using for frequency, so

If you are using COUNTIF then

=COUNTIF(A$1:A$9,C1)

No array needed and no check for the NA.

If you are using FREQUENCY thent ry the following array entered formula:

=FREQUENCY(IF(ISNA(A1:A9),"",A1:A9),C1:C4)

Where A1:A9 is your data, C1:C4 is your bin range.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Saintsman" wrote:

How do I calculate the frequency for a set of numbers which includes #NA
error ie ignore the error

Thanks