All Questions
75
questions
0
votes
0
answers
42
views
Need to get a total number of employees on schedule with 15 min intervals, but only the employees that end their shifts after midnight
I am making a work schedule to know how many agents I have every 15 minutes. I have the formula =SUMPRODUCT(--( E3>=B$3:B$47),--(E3<C$3:C$47)) which works great as my start times are in B3, my ...
1
vote
2
answers
71
views
Is there a way to count occurrences of a number in an array based on a single column value in excel?
Category
Score 1
Score 2
Score 3
Score 4
4
3
1
5
4
3
4
2
6
4
4
5
5
5
5
5
4
6
5
6
I'm trying to count the unique instances of each score for each category across the range of Scores. For example ...
0
votes
1
answer
364
views
CountIf formula with VBA
I have a spreadsheet that has Agreement numbers (RA), but sometimes there are duplicate RA numbers because there is a second invoice (which is not unique). I need to identify when there is a second ...
0
votes
0
answers
40
views
[Excel]- How Can I use Countifs that must satisfy both criteria for it to count?
So I am using the below code
=COUNTIFS('Incident Register'!M2:M208,"Condition of the Workplace",'Incident Register'!C2:C208,Sheet1!J8)
First condition goes over the incident register and ...
0
votes
1
answer
1k
views
Excel Combining Countif and Vlookup
Table 1 (input):
Name
Value
Bob
0.5
John
1.2
Bob
0.3
John
0.1
Jane
3
Table 2 (expected output):
Name
>=0 & <1 Count
Bob
2
John
1
Jane
0
I'm looking to count the names in Table2 (...
0
votes
1
answer
307
views
Excel Cell reference of a text string + Wildcard?
I have a list of cell with different conditions under a column called "Status".
I am trying to make a summary COUNTIF for each occurrence of a status. Single mentions are easy, like "...
1
vote
1
answer
193
views
Get duplicates from two columns
I'm having trouble filtering an excel table. M, it is a set of two rows from two tables, where it is necessary to find duplicates.
2 rows with duplicates
Some idents are repeated, they are present ...
0
votes
1
answer
30
views
Excel formula using countif on sample data
We want to find out how many Data00_A_Up and Data00_B_Up is there , we are not concerned about the digit which comes after A and B like A1,A2,B1,B2 and all. For all Data, that is Data00,Data01,...so ...
0
votes
0
answers
364
views
Excel Formula that identify whether a date is in the list of dates
I have a list of dates in Excel :
22/07/2022, 23/08/2022, 24/09/2022
I want to identify whether a specific date (current date) is in the list of dates. (E.g. 24/09/2022)
What formula shall I use ?
I ...
0
votes
0
answers
71
views
DateIF and countif? Excel formula
I have a list of IDs that have multiple dates and I am trying to count the months for each specific eeid to calculate a timeframe how long someone is on medication.
So far, I did a countif(A:A,A) ...
0
votes
1
answer
36
views
IF / COUNTIF statement to provide an overall outcome based on multiple options
I have hit a bit of a wall and it is probably an easy fix for someone. I am trying to place an overall grade on excel based on previous entries.
Range is E73:E88
Possible outcomes on those ranges are ...
0
votes
1
answer
298
views
Excel Dynamic Countifs range
Can a countifs range be dynamic?
I'm simply trying to do a countifs formula in a worksheet that is likely to grow, currently I have the upper bound set to 10000 but since I'm trying to count the ...
0
votes
0
answers
29
views
Google Sheets: How to use IF, ROW and SUMIF in this specific case
I have a table with the following columns: Branch, Code, Quantity, Code, Quantity, Code, Quantity.
I need a formula that looks for a specific Branch and if the branch is correct summarize all the ...
0
votes
1
answer
38
views
Count If formula
I need to count how many affiliates each company has. However, there are numerous affiliate names and companies, so I am getting confused which formula would count the affiliates per company, when ...
0
votes
1
answer
318
views
COUNTIFS - drag down, fill condition linearly:
I need to drag this formula down and increase condition 5, (3rd argument) in ASC: 5, 6, 7, 8... and keep everything else the same. Does anyone know how? Any help will be greatly appreciated.
=COUNTIFS(...