Why won't Excel calculate formulas on this spreadhseet. It's acting like
there is no data in the cells. We are putting in =Average(B2:B286) and doing
this in each column from column B - P for average and median. Its' returning
#DIV/0! Three very good Excel people here have tried. Why is it not
calculating data? We noticed that when we typed the value back into one or
two cells in "B" that it calculated a median and average. So, why buy
software if I have to type in values from B - P from 2 - 286!!??? Why won't
Excel calculate this? What's the answer to get it to recognize the data that
is in fact there. The formulas are correct also!!!!!!!!!!!!!!