SUBTOTAL COUNTIF formula in Excel.

G

Guest

I would like to be able to filter data in my Excel spreadsheet and then count
the cells in the filtered column that contain numbers that are greater than
or equal to a certain number. The only subtotal count options that I found
were Count and CountA. Is there a way around this?
 
D

Don Guillett

try using sumproduct on ALL the data with the same conditions for the filter
=sumprocuct((rnga=reasonforfilter)*(rngb>=23))
 
A

Aladin Akyurek

Using a setup due to Longre...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(NumberRange,ROW(NumberRange)-MIN(ROW(NumberRange)),,1)),--(NumberRange>=N))

where N is the criterion number and NumberRange is the range of numbers.
 

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

need help on either doing a loop and counting specific values orusing subtotal function 2
Countif problem 2
COUNTIF___Visable only 4
Subtotal of values in cells containing formula 1
conditional constraints on subtotal fn 5
Subtotal and Countif 1
Excel Need Countifs Formula Help 0
CountIF in a subtotal? 3

Top