I've had a search and found lots of threads on this but not one that answers my problem. This isn't how my spreadsheet is but the quickest way I can explain what I need:
A1-A4 - Are staff wages
C1-C6 - Are separate expenses
D1-D6 - Are each the same drop down list of staff names who need the adjacent expense adding to their wage
The formulas I need:
B1-B4 - Staff wages including any expenses they are listed next to
I can figure it out for one lot of expenses but when I get to the 2nd I start to struggle, could you help how I add the other IF functions in?
=IF(D1="Staff Name",+C1,"")+A1
A1-A4 - Are staff wages
C1-C6 - Are separate expenses
D1-D6 - Are each the same drop down list of staff names who need the adjacent expense adding to their wage
The formulas I need:
B1-B4 - Staff wages including any expenses they are listed next to
I can figure it out for one lot of expenses but when I get to the 2nd I start to struggle, could you help how I add the other IF functions in?
=IF(D1="Staff Name",+C1,"")+A1
Last edited: