Subtotal

  • Thread starter Thread starter KC
  • Start date Start date
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
 
=SUMPRODUCT(SUBTOTAL(3,OFFSET(F3:F368,ROW(F3:F368)-MIN(ROW(F3:F368)),,1)),--(F3:F368>1))
 
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

Average of Subtotals in Pivot Table 0
Need help creating a running subtotal 2
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Subtotal percentage 1
Subtotaling 3
Subtotal and Auto-filter 2
Sumproduct Ignore Text 2
subtotal function won't work 1

Back
Top