Embed a countif function in subtotal function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I set up a formula to count only from the VISIBLE rows (Filter is on)
the cells that fulfill another condition? Ie Countif it's equal to 1, but
only from the rows that are visible?

Thank you very much,

Dan
 
Try...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(A2:A10,ROW(A2:A10)-ROW(A2),0,1)),--(A2:A10=
1))

Hope this helps!
 

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

Excel Need Countifs Formula Help 0
using CountIF function or Array? 3
CountIf previous cell formula 0
SUBTOTAL and COUNTIF (or SUMIF) combination 2
Using Countif with autofillter 4
countifs Function not giving desired result with date criteria 2
CountIf with And 0
countif only visible cells (filtered) 8

Back
Top