HELP - my formulas won't work

J

Jennifer

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?
 
M

Mike H

Hi,

Put a 1 in a cell and copy it, select these 'numbers' and then

Edit|Paste special - select multiply - Ok

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas 1
#DIV/0 error 2
Need help with a formula 3
Ignore Errors 3
How do I create 2 formulas that faily more eloquently? 2
IF and THEN statements 5
IRR returns DIV/0 4
Formulas 1

Top