View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Using "or" in criteria

Why not use
=SUM(('Test Map'!G2:G124="R")*('Test Map'!I2:I124="Anchor"))
+ SUM(('Test Map'!G2:G124="R")*('Test Map'!I2:I124="A"))


"Maureen" wrote:

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?