Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data in excel wont autosum
I've copied and pasted some figures from a PDF document, now I cannont get
excel to autosum. There is quite a bit of data and don't really care to hand jam it. This has worked in the past, but not so cooperative this time. Any suggestions are appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data in excel wont autosum
Try this
=SUMPRODUCT(--(A1:A6)) alter the range to suit Mike "Frusterated" wrote: I've copied and pasted some figures from a PDF document, now I cannont get excel to autosum. There is quite a bit of data and don't really care to hand jam it. This has worked in the past, but not so cooperative this time. Any suggestions are appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data in excel wont autosum
Frusterated wrote:
I've copied and pasted some figures from a PDF document, now I cannont get excel to autosum. There is quite a bit of data and don't really care to hand jam it. This has worked in the past, but not so cooperative this time. Any suggestions are appreciated. Excel could be seeing the data as text. Put a zero in an empty cell and then copy it. Select all of your data and Paste Special / Add. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format from excel to CVS file wont. Change in CVS wont stay. | Excel Worksheet Functions | |||
Excel data in text, wont update to time format | Excel Discussion (Misc queries) | |||
Excel 2003's autosum does not update data in real time | Excel Worksheet Functions | |||
excel spread sheet wont caculate new data entered in ranges. | Excel Discussion (Misc queries) | |||
Installed Excel Viewer 2003 but it wont download email data | Excel Discussion (Misc queries) |