Feb 17 2019 07:34 PM
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
All Report
Amendments
Client Enquiries
Correspondence
File to Site
Other
Variations
Data Options 2
To Be Completed
Completed
On Hold
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.
Feb 17 2019 10:06 PM
Feb 19 2019 02:10 PM
Hey Eva,
Any chance you know what COUNTIF formula to use?
Ive tried a couple and they haven't worked!
Feb 21 2019 02:41 PM
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")