Excel stops working after column L

  • Thread starter Thread starter Arlen
  • Start date Start date
A

Arlen

Hello Readers,

I have a spreadsheet that keeps a running average of daily
production at a dental office. The cell where this number
is dynamically displayed references a row of cells where
each day's number is kept statically. Those numbers are
derived from this formula:

=IF(ISERROR(SUM($D15:K15)/COUNT($D15:K15)),"",SUM
($D15:K15)/COUNT($D15:K15))...

....so logical, it sums each day's production (stored in
row 15, D and beyond) and divides only by the number of
days we actually had production. This all works fine
until column L, on this month's spreadsheet anyway. The
problem is the COUNT -- there is nothing in column L, row
15, but the COUNT goes up by one, throwing off the
division and every number henceforth. I changed the font
color to make sure there wasn't something hidden, so I
don't know what the formula is Counting. Any ideas?

Also, if I wanted to add another condition to this IF
statement, saying not to SUM or COUNT any cell under
$1000, what would be the proper syntax?

Thanks for reading, and have a great SUMMER!

Arlen
 
I just tried, without success, to replicate your problem. But, you might
like this array formula better
=AVERAGE(IF(d15:k15>0,d15:k15))
The above must be entered/edited as an ARRAY formula with
control+shift+enter (CSE)
 
Hi
maybe a space in this cell?
Try selection the cell and hitting DEL. does this help?
 
Alright, thanks to both of you. I substituted SUMIF and
COUNTIF for SUM and COUNT in the 2nd part of that formula
and copied it along the entire row, and it seemed to fix
it, so perhaps there was a space.

The average thing also works, and much simpler.

Thanks, everybody.
 
Back
Top