Reply to thread

Message: [QUOTE="Max, post: 3342943"] You could be facing 2 issues, text formatting (formulas placed in cells which are inadvertently pre-formatted as text do not respond) and due to text numbers imported (text numbers will not respond to formulas) Try this: Select the entire sheet with the imported data, format it as general (via Format > Cells > General > OK). That "clears" it of all text formatted cells. Then go to a new sheet (just to be sure), copy an empty cell. Then come back to your sheet with the imported data, select the data range, right-click > paste special > check "add" > ok. That should convert all text numbers at one go to real numbers, w/o impacting the real numbers already there, if any. Btw, your: =sum(E2+E4+E6..) should just be: =sum(E2,E4,E6..) -- Max Singapore [URL]http://savefile.com/projects/236895[/URL] Downloads:19,000 Files:362 Subscribers:62 xdemechanik [/QUOTE]