Thread: calculating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger
 
Posts: n/a
Default 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?