Thread: Using "or" in criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maureen Maureen is offline
external usenet poster
  
Posts: 32
Default Using "or" in criteria
I have a formula that allows for individual criteria:

=SUM(('Test Map'!G2:G124="R")*('Test Map'!I2:I124="Anchor"))

I would like the 2nd part of the formula to allow for either "Anchor" or "A".

Any ideas how I can incorporate?
Reply With QuoteReply With Quote