Forum Discussion
COUNTIF Formula
I am trying to get a formula to calculate the following How many times does “All Report “ say “ To Be Completed” I have multiple options that I want to calculate for the total of how many the...
Hey Jane,
There is a couple of ways depending of what you are after.
If you want to count how many times "All report" is in "Category" use
=COUNTIF(E:E;"All Report")
if you want to count the amount of times you have "All Reports" in "Column" and "To Be Completed" in "Status" use:
=COUNTIFS(E:E;"All Report";F:F;"To Be Completed")