This is simpler than my previous in post #6 and no longer requires helper columns or lookup table.
In the Name Manager Full_Part formula tryThe CF formulas remain the same as before.Formula:
=SUMPRODUCT((Sheet1!$A2=Sheet1!$A$2:$A$10)*(Sheet1!C$2:C$10={"Full time","Part time"})*{1,0.75})
Bookmarks