Try this ...

=SUMPRODUCT(--(LEFT($A$2:$A$15,3)="888"),--($B$2:$B$15="FRED"),--($D$2:$D$15="UK"))