Subtotal

K

KC

Hi,

I use =SUBTOTAL(2,F3:F368) to count a column of $ values.

How can I ammend the SUBTOTAL formula to only count values greater
than 1.00?

Tks, Kay Seeton
 
A

Aladin Akyurek

=SUMPRODUCT(SUBTOTAL(3,OFFSET(F3:F368,ROW(F3:F368)-MIN(ROW(F3:F368)),,1)),--(F3:F368>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

Combine Sumifs with Subtotal 0
need help on either doing a loop and counting specific values orusing subtotal function 2
Need help creating a running subtotal 2
Vlookup a subtotal 2
Counting dates in filtered column 1
Sumproduct Ignore Text 2
Calculations of Cell after Autofiltering 0
subtotal excluding spaces "" 0

Top