Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum function not summing???
(x-posted to all applicable groups)
Excel 03 OK, I'm trying to sum numbers a column. This is exact representation, cells F19 to F22: $11,087 $3,400 $2,400 $1,211 I sum into F23 and get the result of only F19 *$11,087.* F23 cell formula shows as =SUM(F19:F22) This is a sheet I downloaded. I added a row (F21) to insert the $2400. When first sum action didn't work, I thought maybe it was based on cell format, so I reformatted to label them currency (this shows in cell properties), so it's not an issue of cell format standardization. Also, I copied the numbers from F column to a new one and pasted as *Special -- values only* and STILL get only the result of the top #, $11,087. WTF??? and What can I do???? |
#2
|
|||
|
|||
sum function not summing???
Try clicking on the cell containing "$2,400". Press F2. Then press Enter.
Sounds stupid, but I've seen it happen. Anything change? Good Luck. Paul "RedHeadedMenace" wrote in message ... (x-posted to all applicable groups) Excel 03 OK, I'm trying to sum numbers a column. This is exact representation, cells F19 to F22: $11,087 $3,400 $2,400 $1,211 I sum into F23 and get the result of only F19 *$11,087.* F23 cell formula shows as =SUM(F19:F22) This is a sheet I downloaded. I added a row (F21) to insert the $2400. When first sum action didn't work, I thought maybe it was based on cell format, so I reformatted to label them currency (this shows in cell properties), so it's not an issue of cell format standardization. Also, I copied the numbers from F column to a new one and pasted as *Special -- values only* and STILL get only the result of the top #, $11,087. WTF??? and What can I do???? |
#3
|
|||
|
|||
sum function not summing???
Maybe its downloaded as text. Is there an apostrophe before each figure?
Suggest re-enter as numbers Geoff -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200510/1 |
#4
|
|||
|
|||
sum function not summing???
nope. I'm stumped. Seems no answer I've gotten has helped :-(
"PCLIVE" wrote: Try clicking on the cell containing "$2,400". Press F2. Then press Enter. Sounds stupid, but I've seen it happen. Anything change? Good Luck. Paul "RedHeadedMenace" wrote in message ... (x-posted to all applicable groups) Excel 03 OK, I'm trying to sum numbers a column. This is exact representation, cells F19 to F22: $11,087 $3,400 $2,400 $1,211 I sum into F23 and get the result of only F19 *$11,087.* F23 cell formula shows as =SUM(F19:F22) This is a sheet I downloaded. I added a row (F21) to insert the $2400. When first sum action didn't work, I thought maybe it was based on cell format, so I reformatted to label them currency (this shows in cell properties), so it's not an issue of cell format standardization. Also, I copied the numbers from F column to a new one and pasted as *Special -- values only* and STILL get only the result of the top #, $11,087. WTF??? and What can I do???? |
#5
|
|||
|
|||
sum function not summing???
no apostrophes. I had pretty much already checked the format to try both
*currency* and *number* and cell properties show this *took* -- but I still can't get a sum. :-( Also, I'm only referrign to a small part of this doc . . . there are way more sets of this to do, so I'm trying to avoid having to manually enter/copy the numbers. "GRM via OfficeKB.com" wrote: Maybe its downloaded as text. Is there an apostrophe before each figure? Suggest re-enter as numbers Geoff -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200510/1 |
#6
|
|||
|
|||
sum function not summing???
90% sure that the contents in those cells are not numbers, but text.
Why not attach/post you file and let us have a look? "RedHeadedMenace" wrote in message ... (x-posted to all applicable groups) Excel 03 OK, I'm trying to sum numbers a column. This is exact representation, cells F19 to F22: $11,087 $3,400 $2,400 $1,211 I sum into F23 and get the result of only F19 *$11,087.* F23 cell formula shows as =SUM(F19:F22) This is a sheet I downloaded. I added a row (F21) to insert the $2400. When first sum action didn't work, I thought maybe it was based on cell format, so I reformatted to label them currency (this shows in cell properties), so it's not an issue of cell format standardization. Also, I copied the numbers from F column to a new one and pasted as *Special -- values only* and STILL get only the result of the top #, $11,087. WTF??? and What can I do???? |
#7
|
|||
|
|||
sum function not summing???
Red, try clicking on cell F20, press F2, backspace once, and hit enter.
"RedHeadedMenace" wrote in message ... (x-posted to all applicable groups) Excel 03 OK, I'm trying to sum numbers a column. This is exact representation, cells F19 to F22: $11,087 $3,400 $2,400 $1,211 I sum into F23 and get the result of only F19 *$11,087.* F23 cell formula shows as =SUM(F19:F22) This is a sheet I downloaded. I added a row (F21) to insert the $2400. When first sum action didn't work, I thought maybe it was based on cell format, so I reformatted to label them currency (this shows in cell properties), so it's not an issue of cell format standardization. Also, I copied the numbers from F column to a new one and pasted as *Special -- values only* and STILL get only the result of the top #, $11,087. WTF??? and What can I do???? |
#8
|
|||
|
|||
sum function not summing???
Run this macro
http://www.mvps.org/dmcritchie/excel/join.htm#trimall -- Regards, Peo Sjoblom (No private emails please) "RedHeadedMenace" wrote in message ... nope. I'm stumped. Seems no answer I've gotten has helped :-( "PCLIVE" wrote: Try clicking on the cell containing "$2,400". Press F2. Then press Enter. Sounds stupid, but I've seen it happen. Anything change? Good Luck. Paul "RedHeadedMenace" wrote in message ... (x-posted to all applicable groups) Excel 03 OK, I'm trying to sum numbers a column. This is exact representation, cells F19 to F22: $11,087 $3,400 $2,400 $1,211 I sum into F23 and get the result of only F19 *$11,087.* F23 cell formula shows as =SUM(F19:F22) This is a sheet I downloaded. I added a row (F21) to insert the $2400. When first sum action didn't work, I thought maybe it was based on cell format, so I reformatted to label them currency (this shows in cell properties), so it's not an issue of cell format standardization. Also, I copied the numbers from F column to a new one and pasted as *Special -- values only* and STILL get only the result of the top #, $11,087. WTF??? and What can I do???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |