Help with formula for multiple criteria

12/31/19
Accepted

=COUNTIF([Academic Yr]:[Academic Yr], OR(@cell = "Fall 2019", @cell = "Prior to Fall 2019"), Status:Status, "Active")

Best Answer

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try changing it to a COUNTIFS (with the S on the end).


    =COUNTIFS([Academic Yr]:[Academic Yr], OR(@cell = "Fall 2019", @cell = "Prior to Fall 2019"), Status:Status, "Active")

  • dakissee108951dakissee108951 ✭✭✭✭

    Thank you. I will give that a try.

Sign In or Register to comment.