Using "or" in criteria
Thanks to all. Your suggestions worked.
"Bernie Deitrick" wrote:
Use + as Or within an array formula:
=SUM(('Test Map'!G2:G124="R")*(('Test Map'!I2:I124="Anchor")+('Test Map'!I2:I124="A")))
HTH,
Bernie
MS Excel MVP
"Maureen" wrote in message
...
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?
|