ExcelBanter - calculating

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - calculating (https://www.excelbanter.com/excel-discussion-misc-queries/71913-calculating.html)

Roger

calculating

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

pinmaster

calculating

Try:

=SUMIF(B1:B100,"your word",D1:D100)

HTH
Jean-Guy

"Roger" wrote:

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

Roger

calculating

Thanks
The problem is that I have multiple words in each cell & I want just to
choose 1

"pinmaster" wrote:

Try:

=SUMIF(B1:B100,"your word",D1:D100)

HTH
Jean-Guy

"Roger" wrote:

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

Fred Smith

calculating

Sumif will accept wildcards in its criteria. Try:

=sumif(B:B,"*word*",D:D)

--
Regards,
Fred

"Roger" wrote in message
...
Thanks
The problem is that I have multiple words in each cell & I want just to
choose 1

"pinmaster" wrote:

Try:

=SUMIF(B1:B100,"your word",D1:D100)

HTH
Jean-Guy

"Roger" wrote:

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

All times are GMT +1. The time now is 08:00 PM.