I Have an attendance tracker i am trying to set up a column that counts how many "s" (for sick day) are in a row for the last 30 days of the day you open the file so i will have a running total of sick days for the past 30 days at any given point in time so far i have something like this but it is not working please help 
=COUNTIFs(E5:NE5,"s"(e4:NE4,today()-30))
E4 to NE4 is the dates 1/1/11 - 12/31/11
E5 to NE5 are the empty cell you can type S in for sick day
=COUNTIFs(E5:NE5,"s"(e4:NE4,today()-30))
E4 to NE4 is the dates 1/1/11 - 12/31/11
E5 to NE5 are the empty cell you can type S in for sick day
Somebody anybody please