Occasional Contributor

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


Client Enquiries


File to Site




Data Options 2

To Be 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.


3 Replies
Hello Jane!

With counting multiple criteria take a COUNTIFS function.

Greets, Eva

Hey Eva,


Any chance you know what COUNTIF formula to use? 


Ive tried a couple and they haven't worked!

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")

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies