ExcelBanter - how to Sumif

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

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

- - how to Sumif (https://www.excelbanter.com/excel-worksheet-functions/130103-how-sumif.html)

Sherries

how to Sumif

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)

Charles Chickering

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)

All times are GMT +1. The time now is 06:35 AM.