conditional sum's

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.
 
M

Mark Graesser

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
[email protected]


----- 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
 
Top