basically on files above
lookup from wip on col F
on matches data sort by col S
if col s begins with B or I give me one total
on the rest of matches give me the remaining total
so should have total for B & I ****
and total for rest ****
Many thanks
Merc