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

Improve this question

2 Answers 2

Reset to default
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")
Improve this answer
1
  • 1
    Dear, thank you very much for your valuable collaboration, it has been very useful for me. A big hug
    – Camila Sanchez
    Commented Jul 22, 2021 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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .