Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIF through filtered data
Hi All, I have a long list data which is alist of employee with their errors made on their work. I have summarized the errors by step and errors type to 2 tables. What I need is to be ablt to choose any one staff by their employee ID and the two tables will automatically change to reflect only their data rather than the entire data. I have attached a simplified version for reference. I need the Summary By Step and Summary by Errors Type to change when I choose any one of the employee by their employee id with the filter function. Is there a way ? Thanks. +-------------------------------------------------------------------+ |Filename: FormulaSumIF.zip | |Download: http://www.excelforum.com/attachment.php?postid=5243 | +-------------------------------------------------------------------+ -- Kumara_faith ------------------------------------------------------------------------ Kumara_faith's Profile: http://www.excelforum.com/member.php...o&userid=37766 View this thread: http://www.excelforum.com/showthread...hreadid=573440 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIF through filtered data
In D14 use
=SUMPRODUCT(SUBTOTAL(3,OFFSET(H$2,ROW($H$3:$H$9)-ROW($H$2),,1)),--($G$3:$G$9 =B14),$H$3:$H$9) etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kumara_faith" wrote in message news:Kumara_faith.2csw1i_1156013409.9671@excelforu m-nospam.com... Hi All, I have a long list data which is alist of employee with their errors made on their work. I have summarized the errors by step and errors type to 2 tables. What I need is to be ablt to choose any one staff by their employee ID and the two tables will automatically change to reflect only their data rather than the entire data. I have attached a simplified version for reference. I need the Summary By Step and Summary by Errors Type to change when I choose any one of the employee by their employee id with the filter function. Is there a way ? Thanks. +-------------------------------------------------------------------+ |Filename: FormulaSumIF.zip | |Download: http://www.excelforum.com/attachment.php?postid=5243 | +-------------------------------------------------------------------+ -- Kumara_faith ------------------------------------------------------------------------ Kumara_faith's Profile: http://www.excelforum.com/member.php...o&userid=37766 View this thread: http://www.excelforum.com/showthread...hreadid=573440 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |