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