Can someone explain me how to implement countif function(more criteria) on filter data. This formula is not ok
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B50,ROW(B2:B50)-MIN(ROW(B2:B50)),,1))*(B2:B50="Quality")) because there is a mistake in offset!
I have
Firm A B C D
1
.
.
.
800 800 800 800 800
I use filter to select couple of firm
Than from column A I want firms that A>=0,4 that is not problem in all data but in filter is problem.
From second column I want firm that meet first criteria and that is filed second criteria B is between 0,3 and 0,4!
=COUNTIFS(Sheet2!$A$3:$A$813;">=0,4";Sheet2!B3:B813;">=0,3";Sheet2!B3:B813;"<0,4") this formula not works in filter data.
Can someone help me!
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B50,ROW(B2:B50)-MIN(ROW(B2:B50)),,1))*(B2:B50="Quality")) because there is a mistake in offset!
I have
Firm A B C D
1
.
.
.
800 800 800 800 800
I use filter to select couple of firm
Than from column A I want firms that A>=0,4 that is not problem in all data but in filter is problem.
From second column I want firm that meet first criteria and that is filed second criteria B is between 0,3 and 0,4!
=COUNTIFS(Sheet2!$A$3:$A$813;">=0,4";Sheet2!B3:B813;">=0,3";Sheet2!B3:B813;"<0,4") this formula not works in filter data.
Can someone help me!