Hello,
I am trying to create a spreadsheet where it will look for a certain date (could be multiple dates) in a table and then it checks if those dates have a 100% percentage, if it does then it adds up the pay and displays the figure. But I'm not sure what formula to use or how to use it so that it does this. So that the end result under "PAY AMOUNT" will show the amount I have to pay if they were 100% in that month.
Could someone help, please?
Kind Regards,
Jacob
Bookmarks