| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP - my formulas won't work
I have a series of data cells for which I am trying to calculate the sum.
When I try to do so, it will just return "0". When I try to calculate the average, it just returns the "DIV/0!" error. I have already tried copying and paste special (values), coping this into another spreadsheet, etc. When I manually input the numbers, however, it works. WHY? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP - my formulas won't work
Hi,
Put a 1 in a cell and copy it, select these 'numbers' and then Edit|Paste special - select multiply - Ok Mike "Jennifer" wrote: I have a series of data cells for which I am trying to calculate the sum. When I try to do so, it will just return "0". When I try to calculate the average, it just returns the "DIV/0!" error. I have already tried copying and paste special (values), coping this into another spreadsheet, etc. When I manually input the numbers, however, it works. WHY? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulas do not work | Excel Worksheet Functions | |||
| formulas do not work | Excel Discussion (Misc queries) | |||
| Formulas do not work any more ? | Excel Discussion (Misc queries) | |||
| formulas don,t work | New Users to Excel | |||
| How can I work around the non value (#N/A) when using formulas in. | Excel Worksheet Functions | |||
Linear Mode
