neodjandre
Well-known Member
- Joined
- Nov 29, 2006
- Messages
- 950
- Office Version
- 2019
- Platform
- Windows
I am using this formula which works but I want to change the part ISTEXT($E$9:$E$297), to IF Cell Value = "J"... Can't figure it out
SUMPRODUCT(--ISTEXT($E$9:$E$297),--ISNUMBER(K$9:K$297))
many thanks,
Andrew
SUMPRODUCT(--ISTEXT($E$9:$E$297),--ISNUMBER(K$9:K$297))
many thanks,
Andrew