SUBTOTAL COUNTIF formula in Excel.

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
try using sumproduct on ALL the data with the same conditions for the filter
=sumprocuct((rnga=reasonforfilter)*(rngb>=23))
 
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.
 
Back
Top