sumif from multiple columns
On Feb 1, 11:06*pm, dcoxdcox
wrote:
I have an list of items with multiple columns of values attached.
Col A = items number (all unique)
Col B = class number (the basis for summarizing)
Col C thru Z = daily values for each item
Row 1 = date
I want *to be able to summarize by class number (which I would normally use
SUMIF) and for selected colums (i.e. one or more days)
In other words - what is the sum of class X on day Y
what formula or formulas would I use?
It depends what version of Excel you are using, in 2007 you just use
the function sumif, but since you haven't figured that out I'm
guessing you aren't.
Try copying this one below the date column you want to sum:
=SUMPRODUCT(($B$2:$B21="X")*(C$2:C21))
Per Erik
|