View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_555_] Rick Rothstein \(MVP - VB\)[_555_] is offline
external usenet poster
 
Posts: 1
Default if then statement based on another column

I provided you with an answer to this same question 12 minutes before you
repeat-posted here again, in as a new thread. In the future, please stay
with your original thread for follow ups and, by all means, check the
responses you get to your original questions.

Rick

"Ann" wrote in message
...
i'm trying to use this formula =SUMIF(B1:B200,"<sent",A1:A200)
if column C is one of 4 statements. how do i use both?
for example, if column c is "A" then SUMIF(B1:B200,"<sent",A1:A200)