Counting elements based on three criteria located in two columns
Solution 1:
Yes, this is possible. The following formula will return the number of "enrolled" + "enrolled-academically completed" that meet the "paid" criteria.
=COUNTIFS(A:A, "ENROLLED", C:C, "Paid")+COUNTIFS(A:A, "ENROLLED -ACADEMICALLY COMPLETED", C:C, "Paid")
Solution 2:
You may also use Sumproduct function.
=SUMPRODUCT((A:A="ENROLLED")*(C:C="Paid")+(A:A="ENROLLED -ACADEMICALLY COMPLETED")*(C:C="Paid"))
