Summary:-
While using COUNTIF function of Excel, the count if function will not work for filterable data as the values will not change as per the data filtered. As on today no other single formula is available for using count if function in filterable data.
To overcome this difficulties, we can use a complex function formula as mentioned below:-
copy paste the below formula and input he field highlighted.
SUMPRODUCT(SUBTOTAL(3,OFFSET(K4,ROW(K4:K38)-ROW(K4),0)),(K4:K38="P4")+0)
Highlighted text are the changeable data we have to input as per our requirements.
No comments:
Post a Comment