Try this ...
=SUMPRODUCT(--(LEFT($A$2:$A$15,3)="888"),--($B$2:$B$15="FRED"),--($D$2:$D$15="UK"))
Try this ...
=SUMPRODUCT(--(LEFT($A$2:$A$15,3)="888"),--($B$2:$B$15="FRED"),--($D$2:$D$15="UK"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks