Combine Subtotal and COUNTIF
Roucouj
Posted messages
3
Status
Member
-
DjiDji59430 Posted messages 4278 Registration date Status Member Last intervention -
DjiDji59430 Posted messages 4278 Registration date Status Member Last intervention -
http://static.ccm2.net/www.commentcamarche.net/pictures/4I7uIKIEPnt3E0ewe7VCLWlJFsoM82hcNLOj2T0PBu6K5kwjRnY63R0XgzO9SXkF-capture-sstt-nbsi.pngHello,
As a novice in Excel, I need to combine the SUBTOTAL and COUNTIF functions so that when I apply filters to my table, the COUNTIF result adjusts and gives me the number of "won" projects.
Currently, when I apply filters, the number of "won" projects remains the same as the number of "won" projects without applying the filter.
If someone could help me out with this, it would be great as I've been stuck on this for a week.
Thank you in advance.
As a novice in Excel, I need to combine the SUBTOTAL and COUNTIF functions so that when I apply filters to my table, the COUNTIF result adjusts and gives me the number of "won" projects.
Currently, when I apply filters, the number of "won" projects remains the same as the number of "won" projects without applying the filter.
If someone could help me out with this, it would be great as I've been stuck on this for a week.
Thank you in advance.
This function only counts cells of the number type (the one on the right), I would like to count the cells with the words "lost" and "won" and be able to get the number of cells marked won when I filter.
Thank you