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