SumIF through filtered data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kumara_faith - 19 Aug 2006 19:49 GMT

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

+-------------------------------------------------------------------

Reply to this Message

Bob Phillips - 19 Aug 2006 23:59 GMT

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.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi All,
>
[quoted text clipped - 13 lines]
> |Download: http://www.excelforum.com/attachment.php?postid=5243 |
> +-------------------------------------------------------------------+

Reply to this Message