#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. |
Tags |
sumif columns |
|
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 |