Thread: how to Sumif
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charles Chickering Charles Chickering is offline
external usenet poster
 
Posts: 272
Default how to Sumif

=SumIf(D2:D80,"=Word",C2:C80)
HTH
--
Charles Chickering

"A good example is twice the value of good advice."


"Sherries" wrote:

I need to add the dollar amount in C2-C80 if the word in d2-d80 matches.
I need the total in g
sum of c2-c80 if d2-d80=word (Total in g2-g13)