Using "or" in criteria
I would prefer using Sumproduct
=SUMPRODUCT(('Test Map'!G2:G124="R")*(('Test Map'!I2:I124="Anchor")+('Test
Map'!I2:I124="A")))
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
"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?
|