Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-29-2016, 11:23 AM
pero978 pero978 is offline sum values in columns Windows 10 sum values in columns Office 2013
Novice
sum values in columns
 
Join Date: Nov 2015
Posts: 13
pero978 is on a distinguished road
Default sum values in columns


hi,
In columns A, C and E have names (names are not always same in all three coulmns). In columns B,D and F i have values. I would like to SUM that values for users in columns A, C and D. So if I have A: Tony Parker, B:2, C:Tony Parker, D:1; E: TOny parker; F:0 > sum is 3
BR
Reply With Quote
  #2  
Old 01-30-2016, 01:15 AM
xor xor is offline sum values in columns Windows 10 sum values in columns Office 2013
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

For example:

=SUMIF(A1:F1,"<"&9^9)
Reply With Quote
  #3  
Old 01-30-2016, 07:46 AM
pero978 pero978 is offline sum values in columns Windows 10 sum values in columns Office 2013
Novice
sum values in columns
 
Join Date: Nov 2015
Posts: 13
pero978 is on a distinguished road
Default

hello
thanks for respons, why is there "<"&9^9?
BR
Reply With Quote
  #4  
Old 01-30-2016, 07:49 AM
xor xor is offline sum values in columns Windows 10 sum values in columns Office 2013
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Just some very big number.

Try to enter for example: =9^9 < "Z"

Last edited by xor; 01-30-2016 at 10:00 AM.
Reply With Quote
Reply

Tags
excel 2013 formula, functions, sum



Similar Threads
Thread Thread Starter Forum Replies Last Post
Display multiple values as new values based on selection from template. MvdB Excel 2 09-29-2015 08:51 PM
Hide rows in multiple columns based on zero values Deane Excel Programming 19 06-23-2015 11:24 PM
sum values in columns Copying and pasting values with unequal data columns grexcelman Excel Programming 5 12-05-2014 11:36 AM
swap values s7y Excel Programming 0 05-15-2012 01:32 PM
sum values in columns How to compare 2 columns with other two columns in EXECL 2007? Learner7 Excel 5 06-12-2010 09:54 AM

Other Forums: Access Forums

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


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