How to use subtotal with a condition

S

S Himmelrich

I currently have within a cell the following function

=SUBTOTAL(2,F:F)

What I want to do is only count any cell value that equals "High
Impact"....how would I change the above function to make that happen,
currently it is providing me a "0"
 

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

Combine Sumifs with Subtotal 0
Word macro that can call cells out of Excel for a find and replace 0
Stuck trying to find a function 3
Countdown macro - display settings 2
Excel - Wich Function should I use? 1
Cumulative formula for word table 0
Macro Pause to Select range then Subtotal 0
Problem with SET & REF function 0

Top