just enter the referenced sheet name prior to the cells.

=SUMPRODUCT(--(Sheet1!L4:L463="x"),--(Sheet1!C4:C463="dr lim"))

Replace sheet1 with your tab name

"Help with cell function" wrote:

this is the formula that works if I put it in the same sheet, but I need to
put it in another sheet.
=SUMPRODUCT(--(L4:L463="x"),--(C4:C463="dr lim"))

"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.