conditional sum's

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I'm trying to sum values based on conditions in two
different arrays (alpha numeric). For example, if the
condition for column 'a' is met and the condition for
column 'b' is met, I'd like to sum the values in
column 'c'.

I want to avoid concatenating the two columns but would
rather use some sort of nested sum procedure to get the
job done.

thanks.
 
Steve
You can use a SUMPRODUCT for this

=SUMPRODUCT((A1:A100="A")*(B1:B100="B")*(C1:C100)

You cannot use a column reference (A:A) and the ranges must be identical in size. You can replace the "A" and "B" with cell references. If you have any text in the C column reference you will get a value error

Good Luck
Mark Graesse
(e-mail address removed)


----- Steve wrote: ----

I'm trying to sum values based on conditions in two
different arrays (alpha numeric). For example, if the
condition for column 'a' is met and the condition for
column 'b' is met, I'd like to sum the values in
column 'c'

I want to avoid concatenating the two columns but would
rather use some sort of nested sum procedure to get the
job done

thanks
 
Back
Top