ExcelBanter - calculating

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - calculating (https://www.excelbanter.com/excel-worksheet-functions/71963-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?

Trevor Shuttleworth

calculating

Try SUMIF

Regards

Trevor

"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 in columm "B" of the same row?

bpeltzer

calculating

=sumif(b:b,"Key phrase",d:d)

"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
How about I want to select only 1 word from the cells of columm B?

"bpeltzer" wrote:

=sumif(b:b,"Key phrase",d:d)

"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 04:35 AM.