SUBTOTAL COUNTIF formula in Excel.

C

Courtney

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
Using <= in countifs statement 1
Counting dates in filtered column 1
Countif or other formula needed for multiple data/critera results 3
Excel 2010 countifs for date range 3
subtotal excluding spaces "" 0
histogram dynamic bin count 0
COUNTIF for 2 columns 7

Top