| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Will not calculate average/median formulas;acts like no data in c.
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!!!!!!!!!!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Calculate data on 2 different worksheets | Excel Discussion (Misc queries) | |||
| How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
| What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions | |||
Threaded Mode
