Conditional Summing up of Cell values

[rajk]

Hi,

I have a situation where I have three columns in excel - say col1, col
and col3.

I need to sum up the entries in col3 ONLY IF col1 = 'apple' and col2
'banana' (both the conditions must be satisfied)

If the summing up of the entries in col3 was dependent only on on
column (say col1 or col2) I could have just used a SUMIF function i
the formula.

But I need to base the summing up of entries in one column on entrie
in TWO other columns together.

Is there a way?

Thanks in advance
Raj

 

[Paul]

Hi,

I have a situation where I have three columns in excel - say col1, col2
and col3.

I need to sum up the entries in col3 ONLY IF col1 = 'apple' and col2 =
'banana' (both the conditions must be satisfied)

If the summing up of the entries in col3 was dependent only on one
column (say col1 or col2) I could have just used a SUMIF function in
the formula.

But I need to base the summing up of entries in one column on entries
in TWO other columns together.

Is there a way?

Thanks in advance
Rajk

Use something like
=SUMPRODUCT((A1:A100="apple")*(B1:B100="banana")*(C1:C100))

Or you can put the conditions in other cells, such as "apple" in A200 and
"banana" in B200 and use
=SUMPRODUCT((A1:A100=$A$200)*(B1:B100=$B$200)*(C1:C100))