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

  • Thread starter Thread starter Gunnar Sandström
  • Start date 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
 
Gunnar,

You basically need to reproduce your filtering:

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

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional SUBTOTAL in XL210 Table 7
Excel Need Countifs Formula Help 0
Is there a formula that returns the number at the bottom of a list 4
Need help with a formula, please!!! 2
Macro or formula to compare columns and give a result of the odd o 2
Subtotals - show all columns? 2
Count only visible formula results 2
summing number of 'y's in a filtered column 3

Back
Top