I have data in 2 columns (A & B)
Column A has numbers in Range A1 to A21 (Numbers from 1 to 20, Excluding heading).
Column B can have 4 values (Open,Closed,Hold,Progress) and is updated in Range B1 to B21 (Excluding Heading)
I am looking for a formula that retrives the Total COUNT of:
Less than 10 from column A and corresponding OPEN and CLOSED from column B
Thanks
Column A has numbers in Range A1 to A21 (Numbers from 1 to 20, Excluding heading).
Column B can have 4 values (Open,Closed,Hold,Progress) and is updated in Range B1 to B21 (Excluding Heading)
I am looking for a formula that retrives the Total COUNT of:
Less than 10 from column A and corresponding OPEN and CLOSED from column B
Thanks