SUMIF

[Guest]

What formula do I use to get a sum for all values from collum "D" only if
there is a particular word (out of a few words)in columm "B" of the same row?

 

[daddylonglegs]

If your word is "banana"

=SUMIF(b:b,"*banana*",d:d)

 

[Bernard Liengme]

This worked for me =SUMPRODUCT(--(ISNUMBER(FIND("dog",B1:B4))),D14)
In B I had text such as "dog sat", "need a dog",
Any use to you?
For explanation see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html

 

[Guest]

thanks so much

 

[Guest]

From: "Brainless" -

Thanks for posting this! I had a thorny problem using ranges and cells with
'00###" formats, and SUMIF worked to get the result I needed. This was a bit
of an inspration for me. You are much more concise and helpful than Excel
"help".

Mark