Thread: can I sum one column if the value of another column is ex. "M"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default 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.


Reply With QuoteReply With Quote