lundi 2 novembre 2020

How can I access the results of a column that has values based on an if statement in Excel?

I have a column [Correct Fees] populated by this statement:

=IF(OR(AND([@[Type of License Rcvd]]="new", [@[Fee Amount Collected]]=50), AND([@[Type of License Rcvd]]="renewal",[@[Fee Amount Collected]]=25)),"True","False")

However, when I try to use the COUNTIF statement:

=COUNTIF(Table1[Correct Fees], "True")/COUNTA(Table1[Correct Fees])

I just get a 0. Same goes for a simple COUNT of the column.

Aucun commentaire:

Enregistrer un commentaire