Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-20-2017, 11:26 AM
FTL FTL is offline Split sum of one single row Windows 8 Split sum of one single row Office 2016
Novice
Split sum of one single row
 
Join Date: Mar 2016
Posts: 5
FTL is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 11-20-2017, 12:09 PM
ArviLaanemets ArviLaanemets is offline Split sum of one single row Windows 8 Split sum of one single row Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

=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))
Reply With Quote
  #3  
Old 11-21-2017, 12:54 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Split sum of one single row Windows 7 64bit Split sum of one single row Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft