I need to work out the daily salary cost by apportioning each workers earnings equally over the period he worked. I tried using the sumifs function, but can't figure out how to reference a cell in the "criteria".
The desired result is shown in yellow on the uploaded spreadsheet.
Screenshot 2021-11-27 at 15.52.11.png
Bookmarks