1

I wanted to ask you if there is a way to perform a count by applying formulas directly, without having to resort to the filter option, through the COUNTIF or COUNTIFS function.

From two criteria found in column A ("ENROLLED"; "ENROLLED -ACADEMICALLY COMPLETED"), I would like to know how many of them meet the "Paid" criteria found in Column C

example

I appreciate your collaboration

Psdt: I am using Office 365 version

In the attached link, you will find the book with the data of the example shown in the image.

Example.xlsx

2

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")
New contributor
vsung is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
1
  • 1
    Dear, thank you very much for your valuable collaboration, it has been very useful for me. A big hug – Camila Sanchez Jul 22 at 16:40
1

You may also use Sumproduct function.

=SUMPRODUCT((A:A="ENROLLED")*(C:C="Paid")+(A:A="ENROLLED -ACADEMICALLY COMPLETED")*(C:C="Paid"))

enter image description here

1
  • Appreciated @Emily, thank you for your contribution, your help has been very useful. A big hug from afar – Camila Sanchez Jul 22 at 16:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.