#DIV/0! but why?

[Grayling]

Cells in column H appear as either numbers or blanks and
are derived from two other columns of numbers - actually,
though I don't think it matters,like this (eg for H2), =IF
(E2<=5,F2,""). K10 has =AVERAGE(H2:H400) but returns the
error message #DIV/0!. I can't see why at all. And if I
overwrite the formula in one or two H cells with numbers
I do get an average rather than the error message. I'd be
very grateful if someone can tell me what's going on. In
anticipation of being shown up as pretty dumb,

regards

Grayling

 

[Leo Heuser]

Grayling

Try checking the values in the one or two
cells in column F corresponding to the
mentioned cells you overwrite in column H
to make the formula work.

 

[Guest]

Thanks, but I'm afraid everything looks OK. Any other
ideas please.

Grayling

 

[Harlan Grove]

Thanks, but I'm afraid everything looks OK. Any other
ideas please. ....

Either H2:H400 contains one or more cells evaluating to #DIV/0! or there are
no cells in H2:H400 evaluating as numbers.

What are the results of the formulas

=SUM(H2:H400)

and

=COUNT(H2:H400)

 

[Grayling]

Thanks.

-----Original Message-----
Grayling

Try checking the values in the one or two
cells in column F corresponding to the
mentioned cells you overwrite in column H
to make the formula work.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Grayling" <[email protected]> skrev i en meddelelse



.