#1
|
|||
|
|||
Split sum of one single row
Hi, In my project i had at first two columns for each year, but things went a little too big. Now my currently last year is the EQ column, and i prefer it that way. However, counting everything was easier with two columns. Since i have one column for each year, i don't know how to sum things. Example: Before i had two rows with, let's say, 1950 --- 1951 30|12 --- 26|10 Etc. > A2=56 B2=22 So since now i have one column for each year, 1950 --- 1951 30-12 --- 26-10 (or 30~12) (26~10) as long as the numbers are split for better understanding. How do i sum in A2 ALL left side numbers and in B2 ALL right side numbers? I tried sumproduct (left ~:~) but i got zero... Thanks. |
#2
|
|||
|
|||
=VALUE(LEFT($A2,Find("/",$A2)-1))+VALUE(LEFT($B2,Find("/",$B2)-1))
=VALUE(MID($A2,Find("/",$A2)+1,100))+VALUE(MID($B2,Find("/",$B2)+1,100)) |
#3
|
||||
|
||||
Please post a sample sheet ( no pics) with some data and expected results
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
excel 2016, sum |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Split function in Excel (split the screen) | Officer_Bierschnitt | Excel | 1 | 07-05-2017 07:02 AM |
how to split pst file | luk | Outlook | 0 | 11-24-2014 10:18 AM |
Split a paragraph | bnyamin | Word VBA | 13 | 10-05-2014 08:18 PM |
How to split .pst file | annabrown8812 | Outlook | 1 | 10-03-2013 04:27 AM |
Split a task | fridos | Project | 2 | 05-30-2011 11:19 AM |