Re: sumif from multiple columns

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Feb 1, 11:06 pm, dcoxdcox <dcoxd...@xxxxxxxxxxxxxxxxxxxxxxxxx>
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
.

Relevant Pages

  • Re: sumif from multiple columns
    ... Col B = class number (the basis for summarizing) ... In other words - what is the sum of class X on day Y ... It depends what version of Excel you are using, ... the function sumif, but since you haven't figured that out I'm ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Closure of span as infinite sums?
    ... element of a set or space in a simple form (like an infinite sum), ... The space Chowever has a Schauder basis. ... All of the commonly-seen separable Banach spaces have Schauder bases. ...
    (sci.math)
  • Re: One problem on linear algebra
    ... > Let me first clarify what I think you mean. ... > general as a sum of decomposable elements and dividing up the ... every nonzero term in our w (with this basis) must start with ...
    (sci.math.research)
  • Re: Can you recommend a good explanation of the proof of the Fourier Transform?
    ... determine 'the strength of a basis function.' ... An accurate term for *one of* the processes. ... If you want to compute a 'sum' then ...
    (comp.dsp)
  • sumif from multiple columns
    ... I have an list of items with multiple columns of values attached. ... Col B = class number (the basis for summarizing) ... SUMIF) and for selected colums ... In other words - what is the sum of class X on day Y ...
    (microsoft.public.excel.worksheet.functions)