Home

COUNTIF Formula

JanePeters_
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

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.

 

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