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
