Try =SUMPRODUCT((B5:F5),--(ISNA(MATCH($B$3:$F$3,$K$3:$K$4,0)))) Holidays in K3:K4
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks