1. ## Table sort

When using the count if formula the totals are in correct. How am I able to have the count if totals changed when utilizing filter.

Thanks

Jim

2. Checkout the subtotal function. It counts (averages, finds min/max, etc) the items that are displayed in a filter

Steve

3. ## filter sort

Hmm !,

sounds familiar. I'll try.

Thanks

4. ## Data filter sort

Not sure . . . ., I need to filter then be able to total the Q's etc. How is this done please feel free to make ant adjustments necessary

James

5. Steve,

I have been away from excel for some time and would like furhter assistance.

6. You can Count the Qs without filtering with the formula:
=COUNTIF(B2:B2431,"Q")

You can subtotal the displayed values after filtering with:
=SUBTOTAL(3,B2:B2431)

The "3" is for COUNTA.

Steve

7. If you want to count visible Qs depending on the applied filter, then:
=SUM(IF(SUBTOTAL(3,OFFSET(\$B\$2:\$B\$2431,ROW(\$B\$2:\$B \$2431)-MIN(ROW(\$B\$2:\$B\$2431)),,1)),IF(\$B\$2:\$B\$2431="Q",1, 0),0))
array entered with Ctrl+Shift+Enter.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•