countif

  • Thread starter Thread starter tim
  • Start date Start date
T

tim

Is there a way to count values greater than 0 in only
visible cells.

Thanks
 
If you are using a filter you can use

=SUMPRODUCT(($B$2:$B$20>0)*(SUBTOTAL(3,OFFSET($B$2,ROW($B$2:$B$20)-MIN(ROW($
B$2:$B$20)),,))))


Where B2:B20 is the range

If they are the result of hidden rows/columns you would need VBA or Excel
2003
 
You must log in or register to reply here.

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
COUNTIF absolute value of cells in a range are > 0 8
Sumproduct question 4
Countif Conditions - Use of conditions that vary by cell value 1
counting numbers within a range 2
Help with Averages/Sums of values returned from IF function 6
countif 3
count cells in a document, but excude cells with a "0" 1

Back
Top