mtrilce
07-15-2018, 03:49 PM
Good afternoon
I have a formula for counting the unique values in row B, according to two conditions related to a range of dates in column C.
What I need is to add a third condition, so that I can count the unique values in B, in the range of dates between July 1, 2018 and 30, 2018 and also those that have the condition of "Terminado" in column D.
I have been able to develop the matrix formula with two conditions, but I do not get the third condition ... Could you help me?
= COUNT (1 / FREQUENCY (YES ($ C $ 5: $ C $ 104> C3; YES ($ C $ 5: $ C $ 104 <= D3; MATCH ($ B $ 5: $ B $ 104; $ B $ 5: $ B $ 104; 0))); FILA ($ B $ 5: $ B $ 104) -FILA (DESREF ($ B $ 5: $ B $ 104 ;;; 1;)) + 1))
Thank you very much
I have a formula for counting the unique values in row B, according to two conditions related to a range of dates in column C.
What I need is to add a third condition, so that I can count the unique values in B, in the range of dates between July 1, 2018 and 30, 2018 and also those that have the condition of "Terminado" in column D.
I have been able to develop the matrix formula with two conditions, but I do not get the third condition ... Could you help me?
= COUNT (1 / FREQUENCY (YES ($ C $ 5: $ C $ 104> C3; YES ($ C $ 5: $ C $ 104 <= D3; MATCH ($ B $ 5: $ B $ 104; $ B $ 5: $ B $ 104; 0))); FILA ($ B $ 5: $ B $ 104) -FILA (DESREF ($ B $ 5: $ B $ 104 ;;; 1;)) + 1))
Thank you very much