count data from one sheet to another
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. |
count data from one sheet to another
=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. |
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. |
count data from one sheet to another
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. |
count data from one sheet to another
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. |
All times are GMT +1. The time now is 06:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com