Andy Brown

Posts: n/a

Sum delimited values in cell

If I have "0.120;0.140;0.200" in a cell, is it possible to get the sum of
the values with a formula (NB: not code)?

=INDIRECT("="&SUBSTITUTE(A1,";","+")) just equals #REF!

TIA,
Andy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
display negative values as a blank cell in Excel	pherozeb	Excel Discussion (Misc queries)	3	January 5th 05 04:40 AM
display negative values as a blank cell in Excel	Pheroze Bharucha	Excel Discussion (Misc queries)	0	January 4th 05 10:51 PM
How to display cell values in wordarts?	Anderson Lee	Excel Discussion (Misc queries)	2	December 28th 04 03:05 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
Modify Row & Cell Contents based upon Cells Values	bpat1434	Excel Worksheet Functions	0	November 7th 04 03:31 PM

All times are GMT +1. The time now is 07:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us