PhBarreto
New Member
- Joined
- Aug 9, 2016
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
Hey guys!
I would like to create a formula that counts the unique values in column G of the TB_incident_task tab with the formula below, which is my current formula.
I tried to create it in the following way (and a thousand other ways :D), but it returns the value 1 which is incorrect, because I have 3 records. I checked using the filters to validate if the formula below is correct.
Could you help me?
Thank you in advance!
I would like to create a formula that counts the unique values in column G of the TB_incident_task tab with the formula below, which is my current formula.
Excel Formula:
=SUMPRODUCT((TB_incident_task!$E$2:$E$8571=Dashboard!C14) * (TB_incident_task!$K$2:$K$8571=Dashboard!$B$5))
I tried to create it in the following way (and a thousand other ways :D), but it returns the value 1 which is incorrect, because I have 3 records. I checked using the filters to validate if the formula below is correct.
Excel Formula:
=SUMPRODUCT((TB_incident_task!$E$2:$E$8571=Painel!C13) * (TB_incident_task!$K$2:$K$8571=Painel!$B$5) / (COUNTIF(TB_incident_task!$G$2:$G$8571, TB_incident_task!$G$2:$G$8571) + (TB_incident_task!$G$2:$G$8571="")))
Could you help me?
Thank you in advance!