Hi all,
I want to be able to display the number of times a specific word/criteria shows up in a filtered column. I am currently trying to use SUMPRODUCT
=SUMPRODUCT(G2:G1000=“Fully Comprehensive”)
The result that comes back from the formula is 11. This is technically correct as this is actually the total number of cells within that specified range that contain the criteria “Fully Comprehensive”. However, I have set my filter option on a different column and there are 3 rows that have been filtered accordingly and there is only one cell in the range that currently contains “Fully Comprehensive”. Therefore I want to see ‘1’ appear as a result of this formula and then as I add more data to this spreadsheet and continue to filter I want to see this number adjust accordingly.
Any help gratefully received.
cheers