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? |
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? |
All times are GMT +1. The time now is 05:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com