SUMIF
 

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?

SUMIF
 

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

SUMIF
 

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" wrote in message
...
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?

SUMIF
 

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

SUMIF
 

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