#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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.
|
#3
|
|||
|
|||
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.
|
#4
|
|||
|
|||
It can do columns or rows (i.e. one-dimensional ranges), but not both at the same time (i.e. two-dimensional).
|
Tags |
sumif columns |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create multiple dissimilar columns in Word? | cmnielsen | Word Tables | 4 | 01-31-2015 01:45 AM |
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 |
how to center text in multiple columns | galiwock | Excel | 1 | 05-12-2010 09:02 AM |
Multiple criteria in SUMIF? | pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |