Adding (Distinct) Advanced Filtered Rows

  • Thread starter Thread starter kukarooza
  • Start date Start date
K

kukarooza

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
 
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"))
 
Back
Top