excel 2003 visual basic intermediate course - using count function filtered

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Using count function with filtered tables | Excel forum

excel 2003 visual basic intermediate course - Using count function with filtered tables | Excel forum

resolvedResolved · Low Priority · Version Standard

Samina has attended:
Excel Advanced course

Using count function with filtered tables

I have a table which I use filters on. Is there a way to apply the count function so that it counts the filtered results?

RE: Using count function with filtered tables

Hi Samina

Thank you for your question.

You should be able to use the COUNTIF function to do this, for example, say you have two products, A and B, and you have filtered the product column to show only product A.

In a cell underneath the filtered results, you can enter the COUNTIF function. In this example =COUNTIF(cell range,"A")
where cell range is the range of cells within the Product column which show the letter A. Any text that you are looking for (in this example, the letter A) needs to be entered inside double quotation marks in order that you get a result. If you are counting how many times a specific value occurs, then you don't require double quotations around the value.

You can use this function without filtering first as well.

I hope this helps.
Amanda

RE: Using count function with filtered tables

Thank you! For both speedy replies. I shall give it a go today. :)


 

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips


Server loaded in 0.11 secs.