count data from one sheet to another
Sean, where do I copy this formula?
"Sean Timmons" wrote:
=SUMPRODUCT((Sheet1!$C$2:$C$458=A1)*(L4:L458="x"))
Should get it for you.
"Help with cell function" wrote:
I have 2 worksheets. The 1st is "consult tracking" In this sheet I have
columns of "inappropriate consults" cell (L4 - L458) that gets an x if
criteria is met and "provider" cell (C4 - C458) that gets a providers name
ie. burt.
The 2nd sheet is "inappropriate" that has provider names and needs to be
able to count the totals from the sheet "consult tracking" Is this possible?
I want the cell in "inappropriate" (B!) to count the information from
consult tracking.
|