A formula that only shows the number of ex: "A" in a column and

  • Thread starter Gunnar Sandström
  • Start date
G

Gunnar Sandström

Hi!
Can i make a formula that only shows the number of ex: "A" in a column and
ignore any hidden rows that result from filtering.

Maybe i ca combine
=SUBTOTAL(3;P:p) and
=COUNTIF($P:$P;"=A") in some way?
Regards Gunnar
 
B

Bernie Deitrick

Gunnar,

You basically need to reproduce your filtering:

=SUMPRODUCT((P1:p10="A")*(B1:B10="B")*(C1:C10="C")*1)

HTH,
Bernie
MS Excel MVP
 
Top