Thread: SUMIF with "OR" criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SwtHapa8 SwtHapa8 is offline
external usenet poster
  
Posts: 2
Default SUMIF with "OR" criteria
Hello, I'm having an issue with an IF-THEN formula. In my situation, I'm
trying to say," If A1:A5
= CA or DE or NJ or NY or PA or WI, then sum B1:B5"

Can anyone help?

Column A Column B
CA 2
NJ 3
DE 4
SC 5
TN 6

Reply With QuoteReply With Quote