In Column F, I am getting a total of "Refusals" based on the following formula:
Column F – Number of Refusals
=COUNTIF('Pivot Table'!F:F,"Treatment, No Transport")+COUNTIF('Pivot Table'!F:F,"No Treatment, No Transport")
Column I - List different types of Review Status, such as "Complete", "In Progress" and "Not Reviewed". I am trying to get the total number of "Refusal" that have been "Reviewed" by using the following formula:
=COUNTIF('Pivot Table'!F:F,"Treatment, No Transport")+COUNTIF('Pivot Table'!F:F,"No Treatment, No Transport")*('Pivot Table'!I:I<>"Not Reviewed")
Results are:
Refusal - 48
Reviewed - 48
The number of “Refusals” are correct , but the number of “Reviewed” should be 45.
What am I doing wrong?
Column F – Number of Refusals
=COUNTIF('Pivot Table'!F:F,"Treatment, No Transport")+COUNTIF('Pivot Table'!F:F,"No Treatment, No Transport")
Column I - List different types of Review Status, such as "Complete", "In Progress" and "Not Reviewed". I am trying to get the total number of "Refusal" that have been "Reviewed" by using the following formula:
=COUNTIF('Pivot Table'!F:F,"Treatment, No Transport")+COUNTIF('Pivot Table'!F:F,"No Treatment, No Transport")*('Pivot Table'!I:I<>"Not Reviewed")
Results are:
Refusal - 48
Reviewed - 48
The number of “Refusals” are correct , but the number of “Reviewed” should be 45.
What am I doing wrong?