Countif

S

seibes

I was wondering if there is a way to use countif or something similar
to count only visible cells. I know of subtotal but to the best of my
knowledge there is no countif function tied to subtotal. Basically i
have a column with a yes, no, and an n/a; I need to count how many of
those there are when they are unfiltered and when they are filtered by
other columns in my spreadsheet. Thanks.
 
J

JE McGimpsey

seibes said:
I was wondering if there is a way to use countif or something similar
to count only visible cells. I know of subtotal but to the best of my
knowledge there is no countif function tied to subtotal. Basically i
have a column with a yes, no, and an n/a; I need to count how many of
those there are when they are unfiltered and when they are filtered by
other columns in my spreadsheet. Thanks.
Click to expand...

One way:

=SUMPRODUCT(--(rng="yes"),SUBTOTAL(3, OFFSET(rng, ROW(rng) -
MIN(ROW(rng)),,1)))
 

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

Using <= in countifs statement 1
need help on either doing a loop and counting specific values orusing subtotal function 2
countifs Function not giving desired result with date criteria 2
Identical looking cells 2
Count Number of Unique Cells That Don't Have Certain Characters 0
Using COUNTIF but blank cell if zero 3
Excel 2010 countifs for date range 3
countif function 6

Top