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