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

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