SumIF through filtered data

[Kumara_faith]

Hi All,

I have a long list data which is alist of employee with their error
made on their work. I have summarized the errors by step and error
type to 2 tables. What I need is to be ablt to choose any one staff b
their employee ID and the two tables will automatically change t
reflect only their data rather than the entire data.

I have attached a simplified version for reference. I need the Summar
By Step and Summary by Errors Type to change when I choose any one o
the employee by their employee id with the filter function. Is there
way ? Thanks

+-------------------------------------------------------------------
|Filename: FormulaSumIF.zip
|Download: http://www.excelforum.com/attachment.php?postid=5243
+-------------------------------------------------------------------

 

[Bob Phillips]

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" <[email protected]>
wrote in message
news:[email protected]...