Adding (Distinct) Advanced Filtered Rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kukarooza - 05 Oct 2004 13:20 GMT

I have a column (Column A) of ID numbers that I have filtered so I won'
have any duplicates. In column B, there is data for each ID. (Column
has either F/T or P/T in it, next to each respectful ID). What I nee
to do is add the filtered rows to decide how many are F/T and how man
are P/T. When I try to do this, I keep getting a number that als
counts the filtered out rows, therefore giving me a much larger numbe
than I should have. Could someone please help?

Thanks in advance! :rolleyes

Reply to this Message

Don Guillett - 05 Oct 2004 13:38 GMT

Have a look in HELP index for SUBTOTAL

Signature

Don Guillett
SalesAid Software
donaldb@281.com

>
> I have a column (Column A) of ID numbers that I have filtered so I won't
[quoted text clipped - 6 lines]
>
> Thanks in advance! :rolleyes:

Reply to this Message

Frank Kabel - 05 Oct 2004 13:42 GMT

Hi
try for example:
=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX($A$1:$A$100,1,1),ROW($A$1:$A$100
)-ROW(INDEX($A$1:$A$100,1,1)),0))=1),--($B$1:$B$100="F/T"))

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I have a column (Column A) of ID numbers that I have filtered so I won't
> have any duplicates. In column B, there is data for each ID.

(Column B

> has either F/T or P/T in it, next to each respectful ID). What I

need

> to do is add the filtered rows to decide how many are F/T and how

many

> are P/T. When I try to do this, I keep getting a number that also
> counts the filtered out rows, therefore giving me a much larger

number

> than I should have. Could someone please help?
>
[quoted text clipped - 5 lines]
> kukarooza's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7797
> View this thread: http://www.excelforum.com/showthread.php?threadid=266401

Reply to this Message