Sum first 'x' characters in range of cells

**Paul987** · 09-02-2009, 10:17 AM

I have a list of data in the following format:
1,6
10,66
13,13

I would like to divide the sum the values on the left of the comma and the sum of the values on the right of the comma.

EX. (1+10+13)/(6+66+13) = 24/85 = .2823

This formula will pull off the value on the left side of the comma in cell A1:

=LEFT(A1,FIND(",",A1)-1))

but I'm not sure how to use this formula to sume a range.
Thanks,

**DonkeyOte** · 09-02-2009, 10:20 AM

one approach:

=SUMPRODUCT(--LEFT(A1:A3,FIND(",",A1:A3)-1))/SUMPRODUCT(--MID(A1:A3,FIND(",",A1:A3)+1,100))

**Paul987** · 09-02-2009, 10:48 AM

perfect. Any suggestions on where I can read up on what the "(--" part of the formula is doing? THanks for the help

**DonkeyOte** · 09-02-2009, 10:58 AM

see the link in my sig. to SUMPRODUCT.

**masteff** · 09-02-2009, 02:56 PM

Originally Posted by Paul987

perfect. Any suggestions on where I can read up on what the "(--" part of the formula is doing? THanks for the help

You can also see the discussion here: http://www.excelforum.com/excel-work...-function.html

Sum first 'x' characters in range of cells

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Sum first 'x' characters in range of cells

Re: Sum first 'x' characters in range of cells

Re: Sum first 'x' characters in range of cells

Re: Sum first 'x' characters in range of cells

Re: Sum first 'x' characters in range of cells

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions