formula with search for text, if yes, then sum another colum

[Kmcbrine]

A B C
y $5 dog
y $10 cat
$15 rabbit
y $20 squirrel


so, if column A = "y", then sum all of colmn B where C = dog

I've started with a SUMPRODUCT, but can't finish up.

Any help is much appreciated.

also, how do you attach part of the excel sheet to this forum?

Kerry

 

[Brian from Maui]

Re: formula with search for text, if yes, then sum another c

A B C
y $5 dog
y $10 cat
$15 rabbit
y $20 squirrel


so, if column A = "y", then sum all of colmn B where C = dog

I've started with a SUMPRODUCT, but can't finish up.

Any help is much appreciated.

also, how do you attach part of the excel sheet to this forum?

Kerry

Try,

=SUMPRODUCT(--(A2:A100="Y"),--(B2:B100="DOG"),C2:C100)

 

[Kmcbrine]

thanks - I didn't get an error message, but it didn't pick up the dollar amount either (returned $0) The "dog, cat etc" column is validation list - this should not make a difference?

 

[Brian from Maui]

Re: formula with search for text, if yes, then sum another c

thanks - I didn't get an error message, but it didn't pick up the dollar amount either (returned $0) The "dog, cat etc" column is validation list - this should not make a difference?

Slight variation of the formula I provided. Switch columns B and C, as column B is the range to sum.