ExcelBanter - can I sum one column if the value of another column is ex. "M"

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

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

- - can I sum one column if the value of another column is ex. "M" (https://www.excelbanter.com/excel-worksheet-functions/119091-can-i-sum-one-column-if-value-another-column-ex-m.html)

Wanda

can I sum one column if the value of another column is ex. "M"

I need to sum column D (currancy) if the value of column C is an "M"

I've been trying =SUMIF but can't seem to get it right.

Don Guillett

can I sum one column if the value of another column is ex. "M"

try
=sumif(c2:c22,"m",d2:d22)

--
Don Guillett
SalesAid Software

"Wanda" wrote in message
...
I need to sum column D (currancy) if the value of column C is an "M"

I've been trying =SUMIF but can't seem to get it right.

Allllen

can I sum one column if the value of another column is ex. "M"

=SUMIF(C:C,"M",D:D)
--
Allllen

"Wanda" wrote:

I need to sum column D (currancy) if the value of column C is an "M"

I've been trying =SUMIF but can't seem to get it right.

All times are GMT +1. The time now is 08:44 PM.