count data from one sheet to another

  • Thread starter Thread starter Help with cell function
  • Start date Start date
H

Help with cell function

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.
 
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"))
 
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
 
Back
Top