Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2015, 09:51 AM
SteveBump SteveBump is offline SUMIF not working across multiple columns Windows 7 64bit SUMIF not working across multiple columns Office 2010 64bit
Novice
SUMIF not working across multiple columns
 
Join Date: Oct 2013
Posts: 24
SteveBump is on a distinguished road
Default SUMIF not working across multiple columns


When I use the following SUMIF statement, it does not SUM the values in the 2nd and 3rd columns of the range.

=SUMIF($B$1:$B$10,C20,$L$1:$N$10)

It only sums the values in L1:L10, but does not include M1:M10 or N1:N10.

If I change the range so that it is in the same column; L, M or N, then I get the correct amounts for that column. But it doesn't seem to work if I create a range spanning more than one column.

Am I doing something wrong? Thanks.
Reply With Quote
  #2  
Old 05-13-2015, 03:39 PM
gebobs gebobs is offline SUMIF not working across multiple columns Windows 7 64bit SUMIF not working across multiple columns Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

No that won't work. Sumif will only sum one column. You could sum together three separate ones though. Or there might be an easier solution if you attach your file or a sample of it.
Reply With Quote
  #3  
Old 05-13-2015, 05:22 PM
SteveBump SteveBump is offline SUMIF not working across multiple columns Windows 7 64bit SUMIF not working across multiple columns Office 2010 64bit
Novice
SUMIF not working across multiple columns
 
Join Date: Oct 2013
Posts: 24
SteveBump is on a distinguished road
Default

Thanks. I ended up doing a series of SUMIF statements and adding them together using one for each column. Logically, the way I expected it to work should work since the SUM command can go across columns. Oh well. Thanks for the response.
Reply With Quote
  #4  
Old 05-14-2015, 07:06 AM
gebobs gebobs is offline SUMIF not working across multiple columns Windows 7 64bit SUMIF not working across multiple columns Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

It can do columns or rows (i.e. one-dimensional ranges), but not both at the same time (i.e. two-dimensional).
Reply With Quote
Reply

Tags
sumif columns

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF not working across multiple columns How to create multiple dissimilar columns in Word? cmnielsen Word Tables 4 01-31-2015 01:45 AM
SUMIF not working across multiple columns SUMIF/SUMPRODUCT across multiple sheets/Criterias lukeyb_11 Excel 1 02-14-2014 10:30 AM
Table of Content - Columns not working korric Word 3 05-19-2013 02:33 PM
SUMIF not working across multiple columns how to center text in multiple columns galiwock Excel 1 05-12-2010 09:02 AM
SUMIF not working across multiple columns Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:56 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