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)
|