Hi, I'm just stuck on this & I'm hoping someone can help All I need is the formula to add the Dept in (column A) PI;& RU in (Column B) Melbourne = 4 I believe it could be either a = PI & Melbourne or "<>*Med" but I couldn't get either to...