I'm trying to see if specific data from 3 columns exist and if so,
count it. I'm using defined name ranges instead of using the ranges in
the formulas.

What I'm trying to do is:
See if group "GSC" is true (Name range = Forward)
See if any word that starts with D or UD is true (Name range =
EqualsDev)
See if any word that starts with INV01 is true (Name range =
ForwardINV01)

Here's my attempt...

=SUMPRODUCT((Forward="GSC")*(LEFT(EqualsDev)="D")+ (Forward="GSC")*(LEFT(EqualsDev,2)="UD"),--(LEFT(ForwardINV01,5)="INV01"))

Any suggestions on correcting this or simplifying this would be great.