NewOrderFac33
Well-known Member
- Joined
- Sep 26, 2011
- Messages
- 1,275
- Office Version
- 2016
- 2010
- Platform
- Windows
Good evening - planespotting records time!
The following formula correctly returns a number value of 3286:
=SUMPRODUCT(--(Col_DB_Prefix="G"),--(Col_DB_Category="British Private"),--(Col_DB_Prefix=L5))
but when I amend the third part of the formula to:
=SUMPRODUCT(--(Col_DB_Prefix="G"),--(Col_DB_Category="British Private"),--(LEFT(Col_DB_Prefix,2)=L5))
it returns #VALUE!
I can't for the life of me see what I'm doing wrong, but it might have something to do with the fact that I've been working from home for the last billion years!
Can any of you good folk see where I'm going wrong, please?
Cheers
Pete
The following formula correctly returns a number value of 3286:
=SUMPRODUCT(--(Col_DB_Prefix="G"),--(Col_DB_Category="British Private"),--(Col_DB_Prefix=L5))
but when I amend the third part of the formula to:
=SUMPRODUCT(--(Col_DB_Prefix="G"),--(Col_DB_Category="British Private"),--(LEFT(Col_DB_Prefix,2)=L5))
it returns #VALUE!
I can't for the life of me see what I'm doing wrong, but it might have something to do with the fact that I've been working from home for the last billion years!
Can any of you good folk see where I'm going wrong, please?
Cheers
Pete