ITEM MEMBER QTY FROM
888556 FRED 10 UK
887223 BOB 22 FRANCE
775223 KEV 3 SPAIN
888776 FRED 50 USA
888224 FRED 28 UK
I have attached the actual sheet also, but what I need to find out using the above data, is how many items, that start with 888 has Fred got for the UK?
I have already tried SUMPRODUCT and variations of COUNTIFS, but I have too much criteria to match
Thanks in advance
Bookmarks