Hi all,

Need some help with a sumproduct I've been working on...

=SUMPRODUCT(('Y10 Targets v WAG'!K4:K149<"")*('Y10 Targets v WAG'!F4:F149="A*" OR "A" OR "B" OR "C"))

It's a simple one working on two variables...

Column K must not be blank, and column F must contain any of A*, A, B or C.

Any help greatly appreciated.

Jason