case: SUMIF

[Roger]

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))),D1:D4)
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Roger" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

[Roger]

thanks so much

"daddylonglegs" wrote:

>
> If your word is "banana"
>
> =SUMIF(b:b,"*banana*",d:d)
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=512987
>
>

[Brainless_in_Boston]

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

"daddylonglegs" wrote:

>
> If your word is "banana"
>
> =SUMIF(b:b,"*banana*",d:d)
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=512987
>
>