I am in need of assistance in locating the right formula for my workbook.
in sheet1-I have a list of names, with a current formula " =COUNTIF('Element Core'!A2:A500,'Agent Assignment'!D41)" to capture how much data from each tab they are assigned too.
In sheet2-Shows the actual amount of cells each agent has been assigned to in column A, I would like to somehow divide the completed task in column B of sheet 2 to the total number they have been assigned to in sheet 1.
agent Name - # of cells Assigned too(from sheet 2)
Tom Jerry - 40
I would like to divide 40 by what the agent has already completed in sheet2 on column B.