Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match data, count data and report to diffrent sheet. | Excel Discussion (Misc queries) | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
I want to count *'s that i have put in my sheet ? | Excel Worksheet Functions | |||
UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |