B2=IFERROR(INDEX($G:$G,MIN(INDEX((($C$1:$C$4<>$A2)+($D$1:$D$4<>"Housekeeping"))*10^10+ROW($D$1:$D$4),0))),"")
=IFERROR(INDEX($G:$G,MIN(INDEX((($C$1:$C$4<>$A2)+($D$1:$D$4<>"Housekeeping"))*10^10+ROW($D$1:$D$4),0))),"")
B15=IFERROR(INDEX($G:$G,MIN(INDEX((($C$1:$C$4<>$A15)+($D$1:$D$4<>"Non FB Banquet"))*10^10+ROW($D$1:$D$4),0))),"")
=IFERROR(INDEX($G:$G,MIN(INDEX((($C$1:$C$4<>$A15)+($D$1:$D$4<>"Non FB Banquet"))*10^10+ROW($D$1:$D$4),0))),"")
OR
b2=SUMIFS($G$1:$G$4,$C$1:$C$4,$A2,$D$1:$D$4,"Housekeeping")
=SUMIFS($G$1:$G$4,$C$1:$C$4,$A2,$D$1:$D$4,"Housekeeping")
B15=SUMIFS($G$1:$G$4,$C$1:$C$4,$A15,$D$1:$D$4,"Non FB Banquet")
=SUMIFS($G$1:$G$4,$C$1:$C$4,$A15,$D$1:$D$4,"Non FB Banquet")
Bookmarks