All Questions
100
questions
0
votes
1
answer
349
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. ...
- 17
0
votes
1
answer
281
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>...
- 119
0
votes
0
answers
259
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
1
answer
2k
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 ...
- 15
1
vote
2
answers
518
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 ...
- 212
0
votes
1
answer
313
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 ...
- 11
0
votes
1
answer
78
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 ...
- 5
2
votes
2
answers
4k
views
How to Count Unique Dates for a Given Year in Excel
I have a list of dates in Column A of Excel as follows (header is cell A1):
Date
3/3/2015
3/10/2015
3/10/2015
4/15/2015
4/10/2016
4/29/2016
4/29/2016
5/5/2017
5/5/2017
6/7/2017
11/11/2017
2/3/2018
...
- 156
0
votes
2
answers
83
views
Count specific items separately in 1 cell
I need a formula like COUNTIF for this problem.
Forexample:
I write ''a, b, c, d, d'' in 1 cell, but want them to be counted separately like this:
a -> 1
b -> 1
c -> 1
d -> 2
I tried with ...
- 15
1
vote
2
answers
3k
views
COUNTIF Formula not returning expected values
I'm currently attempting to create a formula for my spreadsheet that will calculate the total completion percentage of the form by counting all "Pass" and/or "Fail" results found within columns B ...
- 51
6
votes
3
answers
1k
views
Count unique value ignoring Text in range
123
562
My Data
548
K166
You
1548
123
562
100
My Data
100
I want to count unique values by ignoring text in the above shown list.
For this I've tried an array formula, {=SUM(1/Countif(,,,,))} but it'...
- 9,274
1
vote
4
answers
673
views
Counting multiple ranged criteria
this is my first post on this forum, so it's probably presented in a very bad way. I am using Excel 2007 to collect some data for my thesis. I have recently learnt how to nest COUNTIFS inside ...
- 51
0
votes
1
answer
53
views
Any way to use function results for a countif conditional in Excel [duplicate]
For example I have a list of dates in A2 through A31 (1st April to 30th April) and want to count the number of weekdays.
In B2 to B31 I could use =WEEKDAY(A2,2)<6 to give true or false. Then ...
- 177
0
votes
0
answers
327
views
Excel COUNTIF gives different result for two different ranges that contain the same matching cell
This is one of the strangest behaviours I have ever seen for Excel...
In cell A3 I have the formula =COUNTIFS(A$101:A$109,"=ERR!"), cells A101 through A109 contain {,"-",,"-","-",,"ERR!",}. This ...
- 11
1
vote
2
answers
421
views
Counting Non-repeat-valued Cells in Excel
I have a column of (text) values. I want to count the number of times a non-blank cell arises such that its value differs from that of the cell immediately above it. I do not want just a sheer count ...
- 137