SumIF through filtered data

[Kumara_faith]

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.

[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]...
>
> 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
>