Hi Grace,

Do you want to display Open and Cancel only in another column?

Please explain!

DJTRIN

Hello Grace,

Not sure how you if you just want a Count the number of times Yes appear in a column but hope this helps;

=CALCULATE (Count (Table Name) [column A]), Table...