Count occurances of a specific cell value in a changing rang of cells

[Acluett]

Row 1 contains several hundred columns of data.
I need to see if a specific character appears 4 times in a set of 28 columns

ie. column 1 to 28, row 1 how many times does 'X' appear, Col 2 to 29 how many times does x appear, col 3 to 30 how many times does 'X' appear, etc etc

The basic reason might help. in any 28 day cycle an employee is required to have at least 4 days off.

The col's represent days, so 365 col's will have data. if the employee worked that day, an 'X' is in that cell, if not "-" is in the cell
I need to count how many times an employee had a day off in each 28 day period

Thanks, I know this is a toughy

 

[Puertorekinsam]

Row 1 contains several hundred columns of data.
I need to see if a specific character appears 4 times in a set of 28 columns

ie. column 1 to 28, row 1 how many times does 'X' appear, Col 2 to 29 how many times does x appear, col 3 to 30 how many times does 'X' appear, etc etc

The basic reason might help. in any 28 day cycle an employee is required to have at least 4 days off.

The col's represent days, so 365 col's will have data. if the employee worked that day, an 'X' is in that cell, if not "-" is in the cell
I need to count how many times an employee had a day off in each 28 day period

Thanks, I know this is a toughy

Where do you want the values to appear? What controls which 28 columns are we looking at?
If the X's are in row 1.
You can put this in A2:

=IF(COUNTIF(A1:AB1,"X")=4, "4 Times", IF(COUNTIF(A1:AB1,"X")>4, " Over 4 Times", "Under 4 Times"))

and as you drag it to the cells to the right it will update.

 

[DRSteele]

Welcome to the forum.

That's not a toughy - it's easypeasy. Put this in Cell AB1 and copy right as far as necessary.

=COUNTIFS(A1:AB1,"X")

 

[Acluett]

but that will count all of the occurences, I only want to count in sequental groups of 28

for example in column #1 there is nothing, column #2 thru column 366 there are either 'x's or '-'s
I need col 1 to sum the total times that their are more than 4 '-''s in a sequential section of cols

IE so for columns 2 thru 29, if there are less than 4 '-'s then col 1 gets 1
columns 3 thru 30, if there are still less than 4'-' than col 1 add 1
Columns 4 thru 31, less the 4'-''s add to col 1 again and so on

 

[Acluett]

In col 1