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 they have entered into a spreadsheet.
Data Options 1
File to Site
Data Options 2
To Be Completed
Each option from List 1 will be paired up with options in List 2. I just want to get the total of how many times the pairs are on the spreadsheet.
Any chance you know what COUNTIF formula to use?
Ive tried a couple and they haven't worked!
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
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")