count data from one sheet to another

  • Thread starter Help with cell function
  • 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.
 
H

Help with cell function

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"))
 
S

Sean Timmons

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting data from sheet to sheet 3
Count the columns from one sheet and paste it in another sheet 0
Match data, count data and report to diffrent sheet. 7
COUNT rows on external sheet if between date range 3
Pulling data from one sheet to another 2
Count if help 6
counting data from one workbook to another 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top