Questions tagged [countif]

COUNTIF generally refers to a worksheet function within a spreadsheet program that counts cells in a range based on a specified condition. This tag can also be used for COUNTIFS, which provides a similar function but allows multiple ranges and criteria.

Filter by
Sorted by
Tagged with
0
votes
0answers
36 views

I want to sum a unique value with specific data. Below is my explanation [closed]

Here is my data format ColA ColB Day Agent1 Day2 Agent1 Day2 Agent1 Day2 Agent1 Day3 Agent1 Day2 Agent2 Day2 Agent3 I want to sum a number of Agents of Day 2 without duplicate ...
0
votes
0answers
60 views

One req to many candidates - Transposing data from one row to multiple rows based on # of positions

I am struggling with finding the right excel formula. Trying to avoid writing script in VBA as user will not be able to maintain it going forward and I found with formulas it is a bit easier. We have ...
0
votes
2answers
102 views

Count first cells in a range of rows, which are higher than 0 and meet criteria

For each column, I would like to count the amount of cells, which are higher than 0, appear for the first time in the row, and meet a criteria in one of the columns. In this example, I would like to ...
0
votes
1answer
51 views

Inputting several values, found from a VLOOKUP function, into a COUNTIF function

This question is about a single function (in a single cell to later extrapolate over a whole table) in Microsoft Excel. I want to find a unique id on another page (amongst other id's in the first ...
1
vote
3answers
31 views

Counting unique values against a subset of a list

I'm trying to count how many unique supervisors a particulate employee has. (See an example data set below.) I'm able to do this in a round about way, but I'm wondering if any of you experts out ...
1
vote
1answer
155 views

SUMIF versus SUMIFS

SUMIF allows to sum using a single criteria, where SUMIFS works with multiple criteria. I tend to find that on many occasions, I've start with SUMIF and then need to add more criteria, so change the ...
0
votes
4answers
38 views

Need To Count Total Number Of Instances Of Values In A Column And Return The Results In Other Cells

I have a situation where I need to count the total number of instances of values in a column and return the results in other cells. Users are going to be provided this Excel sheet as a template and ...
0
votes
1answer
34 views

How to combine multiple COUNTIF in Excel?

I have this formula: =OtherSheet!$B$2*COUNTIF(C6:CX6;OtherSheet!$A$2) It looks in the columns to the right and for each occurrence of a string from the other sheet's A2 it adds the other sheet's B2. ...
0
votes
1answer
74 views

Why does my Excel COUNTIF function always return a value of “0”?

My HTML is: div class="medium-insert-images" data-media-id="47deed170ef76561" data-original-width="590" data-original-height="350" contenteditable="false"figure img src="https://cdn-blog.scorum....
1
vote
1answer
16 views

Multiple values same line COUNTIF

I have a table as follows for a musical instrument casting sheet [titled Song Casting) Here's an MWE: +--------+------+--------+-------+------+--------+---------+ | Song | Bass | Guitar | Drums | ...
0
votes
0answers
28 views

COUNTIFS with multiple criteria across multiple sheets

The data: by day, tracking whether multiple buses are in service or not and the brand of the bus (7 buses in question (each bus has it's own sheet); 2 brands, 2 statuses, all in separate columns in a ...
0
votes
0answers
156 views

Trying to count correct answers quickly in Excel using “>=1” logic

Trying to count correct answers quickly, so I want to count if the cell is >=1. The answers are O (wrong) or 1 (correct). =Countif(V2:FV2),">=1"
0
votes
1answer
35 views

Counting the occurence of active durations by month and into a graph

Lets assume I currently have a spreadsheet that holds the dates of members at a crossfit gym and the duration of their memberships. Date Started Date Ended Member Name 11/27/2019 12/19/2019 ...
0
votes
0answers
33 views

Combining IF Statement with CountIF

I'm having trouble combining an IF Statement with a COUNTIF statement. I have a list where I only want excel to count the cells if it has a value of greater than 0, i.e. if there is an inputted value....
0
votes
1answer
48 views

Excel “IFS” criteria values using cell references

My data consists of a month column A (1 through 12) and a values column B (financial returns) spanning multiple years. How do I count the number of month occurrences in the second half of the year ...
0
votes
2answers
60 views

How to COUNTIFS with OR and >= Operator logic

I've found threads that addressed OR logic or operator logic but none together and it's not working for me. Let's say I have a table like this: Col1 Col2(Date) Col3(Date) I want to use ...
0
votes
1answer
183 views

How to count distinct values in one column for each distinct value in another column in MS Excel?

Say I have the following data in an Excel sheet: Country Fruit USA Banana USA Apple USA Apple USA Orange USA Banana USA Apple UK Banana UK Banana UK Apple I ...
0
votes
3answers
64 views

Excel - Indirect Formula

another question regarding Excel Indirect Formula. I have columns E1:J202 filled with one of the following: Green Amber Red How can I use the indirect formula to count each of the above separately ...
0
votes
1answer
30 views

Count of number of times a max of the dates in two columns is bigger than the date in the third column

I have three columns in a report: a closure date (Col A), an implementation date (Col B) and a target date (Col C). I need to count the number of times an entry is closed or implemented before the ...
1
vote
2answers
50 views

Countif Date Array Formula

I'm trying to build a sheet for tracking compliance with training. I'm needing to build some summary fields, which show how many procedures a person is current on, how many they are out of date with, ...
0
votes
3answers
395 views

Count cells in a column between values until specific value reached in Excel

I am trying to count cells from a column between two values: I have a list which on the range A2:A118. I want to start counting when a specific value is reached and stop when another specific value is ...
0
votes
1answer
31 views

Finding Unique Values across many columns

I'm working on what I thought would be a simple task that has become quite complicated. In Column A, I have a Field Name. In columns B through ANV (1059 columns) I have values associated with that ...
0
votes
2answers
30 views

Count number of rows that have X in cell A or B or C

I think looking at the photo is the easiest way to show what I need: Original Table How do I set up a single formula to count the number of kids who failed an exam section? What I've managed so ...
0
votes
0answers
18 views

Counting blanks or not blank cells in 1 columnmatching criteria in a 2nd

I have a list of trouble tickets with groups in one column and assignee names in another -- if someone is assigned. If no one is assigned, the cell is blank. For each group, I want to count the ...
1
vote
2answers
112 views

Count how many times string is contained within string within a range in excel

I would like to parse through URLs and count how many times a string e.g. 'apple' occurs within a range. I tried =COUNTIF but it's looking for exact matches. I have about 80k rows of URLs and I need ...
0
votes
1answer
65 views

Count If Formula for 2 Separate Criteria

I am trying to write a CountIf Excel formula for 2 separate criteria on the same range. The range consists of a formula that generates a 1 or 2, so the Countif formula tells the user what category ...
0
votes
2answers
66 views

Excel - keep the absolute reference from inserting row using COUNTIFS function

How can I use the absolute reference Column in a different sheet in COUNTIFS function? COUNTIFS(Scenario!C:C,C21,Scenario!H:H,"PASS") We are inserting new column on H, and then the reference range ...
1
vote
1answer
59 views

Sum the Count of Min of each column by row

I am trying to automate a spreadsheet that will keep a running tally of the most negative topics week over week (kind of like Billboard top 100). I have tried to get Column A(No.1) to calculate the ...
0
votes
2answers
273 views

COUNTIFS when criteria has more than 255 characters

I was looking for a formula in Excel that will search into different ranges parts of text that meet another criteria. So, basicalLy it is a COUNTIFS. While trying to use the formula, which perfectly ...
0
votes
0answers
25 views

COUNTIF when wanting a result between certain dates

So I'm in a little bit of a quandary. I'm creating a KPI dashboard, and one of those is the number of meetings booked and then number of meetings sat. I'm creating a weekly dashboard that is ...
0
votes
2answers
58 views

Count If: Using Formula to Create Range

I am trying to create the Range of a CountIf formula, using formulas. I found some data on using INDIRECT, but it doesn't seem to fit the bill. Here is the specific problem: SHEET 1: A B ...
0
votes
1answer
70 views

Count number of rows matching multiple criteria

I'm working with two Excel workbooks. The first one contains this table: The other contains this one: Is it possible with VBA, for each week, to count the number of rows matching three specific ...
1
vote
1answer
49 views

Cross table of joint games

I have a list of games of badminton that have been played over a period of time: Each row contains the game id and one player id. Each game was played with four players. So, for each game there are ...
0
votes
2answers
3k views

Simple regex with Excel COUNTIF to match a substring?

How do I fix this formula: =COUNTIF(A1:A10,"*jim*") to match anything containing the sub-string of "jim" but from a cell, as: =COUNTIF(A1:A10,C11) where cell C11 contains the text "jim"? Perhaps ...
0
votes
1answer
125 views

how to pass a string value into COUNTIF?

For this formula: =COUNTIF(A1:A10,"jim") how can I pass in a variable? That is, let's say that cell C11 has the value "jim"; can I then do something like: =COUNTIF(A1:A10,TEXT_VALUE_OF_CELL(C11)) ...
1
vote
1answer
447 views

How to use Excel to calculate concurrent streaks

I want to use Excel to calculate the "best" and "current" streak in a range of data. Say that a shop's sales target for the day is 500. I have a column which contains the daily sales data for the ...
0
votes
2answers
171 views

Excel – using multiple criteria in COUNTIFS function

I need to create a formula that counts the number of times there is an overdue date in column I, where the corresponding cell in column J is blank. I enter a date in column H (date appointed). There ...
0
votes
1answer
45 views

How to properly use COUNTIFS with a defined named range?

I have a formula that counts the number of contact attempts for each month. The problem I am facing is that the formula only goes up to row 2000. How can I rewrite my formula to adjust with newly ...
0
votes
1answer
300 views

Trying to use the value of a cell for criteria in COUNTIF

I've constructed a gradebook in LibreOffice Calc, and I'm trying to keep track of how many students have scored an A, B, etc., on assignments. Currently, I have the grades for an assignment in a ...
-1
votes
1answer
39 views

Using COUNTIFS function with criteria if a value is in range of values

I need help with COUNTIFS function. There are values in column B: a,b,c,d,e,f,.... I want to use COUNTIFS function to count items in column A, if the values in column B is included in range {a,c,f}
0
votes
1answer
46 views

How can I count the number of occurrences in a range of cells?

I am looking to count the number of times a value is found in a range of cells between two dates. My range is not a table but has headers for "Date", "Time" and "Result". It stretches from $G8:KT$992. ...
0
votes
1answer
168 views

Add a CountIF to a SumProduct Formula

In a previous question, Scott gave me this great formula to sum all the sales from salespeople who saw an increase in sales from 2017 to 2018: =SUMPRODUCT(C2:C9-B2:B9, --(C2:C9>B2:B9), --(B2:B9>...
2
votes
3answers
75 views

How to count cells if it contains a value in Excel

I have an Excel sheet like this: ID | Relations ----+---------------- 1 | , 2 | , 3 | ,1, 4 | ,1,2, 5 | ,2, 6 | ,3, 7 | ,1,2,4, 8 | ,1,2,4,5,6, 9 | ,2,4,5,1, I want to count ...
0
votes
0answers
37 views

Using COUNTIFS to count times within next 6 hours, next 12 hours, etc

I currently have COUNTIFS set up to count times in specific 6 hour time frames, for instance 12:00-18:00, but would like to change it to 6 hour increments FROM the CURRENT time: 6, 12, 18, and 24. ...
1
vote
1answer
152 views

Count multiple letters in different cells

I'm looking for a formula that can count different letters included in different cells. Example: Cell A2 includes a letter "S" Cell A3 includes a letter "F" Cell A4 includes a letter "N" Cell A5 ...
1
vote
1answer
32 views

Excel: Using COUNTIF but not including blanks with other formulas

Firstly, apologies if this is covered somewhere deep within the site, I have looked through a lot of other posts and none of the solutions have worked for me. I'm creating a workbook for a local ...
1
vote
2answers
80 views

Count appearances of two-adjacent-cell value in range (Excel)

I am working on a sports analytics tracker in Excel, and for one part I need to count (I know there are other questions that just need to find them) how many appearances there are of a two-cell value ...
0
votes
1answer
88 views

Countif for Dates

I need a formula for excel that says to countif (G3 >= BK (which is a date) and < BL3 (which is another date. Countif the cell is equal to or greater than a cell, but less than another date(trying ...
0
votes
0answers
40 views

Complex if then arguments in Excel

I have a calendar of months with time off codes on certain days an employee took off and has scheduled off. Codes are "V" for vacation, "PTO" for Paid Time Off, etc. I am trying to input a formula ...
0
votes
1answer
41 views

how to use Countifs function Excel?

from what i have been reading online it appears Countifs function is what i need to use for my problem. I have data that looks like this and goes on for several months: |Month |Day| Time ...