All Questions
6
questions
-1
votes
1
answer
574
views
Excel: How to count how many times a consecutive text value appears
I'm making a work schedule and I have to pay attention to a specific rule that, no worker should be scheduled to work more than 6 days in a row.
I got this spreadsheet where I make those schedules but ...
1
vote
2
answers
15k
views
Simple pattern 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
1
answer
510
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)) ...
0
votes
1
answer
77
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 ...
0
votes
1
answer
58
views
COUNTIFS with dates
I'm trying to get the number of support tickets for each month. In my first tab "Tickets" I have:
The date values have the following characteristics:
In my second tab I have:
I want to know how ...
0
votes
1
answer
509
views
Count instances of a letter in a row if a certain cell in that row contains a specified date
I have a spreadsheet containing a column of dates (week commencing) with columns of data to the right of it, and a conditional formatting rule that highlights this week's row based on the date.
I ...