finding the right formula for adding and dividing

%3CLINGO-SUB%20id%3D%22lingo-sub-1626158%22%20slang%3D%22en-US%22%3Efinding%20the%20right%20formula%20for%20adding%20and%20dividing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1626158%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20in%20need%20of%20assistance%20in%20locating%20the%20right%20formula%20for%20my%20workbook.%3C%2FP%3E%3CP%3Ein%20sheet1-I%20have%20a%20list%20of%20names%2C%20with%20a%20current%20formula%20%22%20%3DCOUNTIF('Element%20Core'!A2%3AA500%2C'Agent%20Assignment'!D41)%22%20to%20capture%20how%20much%20data%20from%20each%20tab%20they%20are%20assigned%20too.%3C%2FP%3E%3CP%3EIn%20sheet2-Shows%20the%20actual%20amount%20of%20cells%20each%20agent%20has%20been%20assigned%20to%20in%20column%20A%2C%20I%20would%20like%20to%20somehow%20divide%20the%20completed%20task%20in%20column%20B%20of%20sheet%202%20to%20the%20total%20number%20they%20have%20been%20assigned%20to%20in%20sheet%201.%3C%2FP%3E%3CP%3Eexample%3C%2FP%3E%3CP%3Eagent%20Name%20-%26nbsp%3B%20%23%20of%20cells%20Assigned%20too(from%20sheet%202)%3C%2FP%3E%3CP%3ETom%20Jerry%26nbsp%3B%20-%26nbsp%3B%2040%3C%2FP%3E%3CP%3EI%20would%20like%20to%20divide%2040%20by%20what%20the%20agent%20has%20already%20completed%20in%20sheet2%20on%20column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1626158%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello,

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.

example

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.

 

Thank you.

0 Replies