Trying to COUNTIF when multiple criteria are met on multiple column data set

I am trying to count the number of emails I receive in a group email box by the time of the day they come in, essentially in 30 minute windows.

Columns S through CA are each a different date with rows 3 through 400 being the raw data of the time each email came in. Each number indicates a time. Times are listed as a number as I thought it would allow me to work with the data easier in terms of coding. For example 730 equals 7:30. Rows 3 through 199 are AM times and rows 200 through 400 would be PM times. So 730 if in row 3 through 199 would be 7:30am. 730 if in row 200-400 would be 7:30pm.

So here is what I am trying to do. To see the number of emails that came in from 8am through 8:29am I am trying to do a COUNT that looks for all the numbers that show up in $S$3:$CA$199 that are >=800 and that are <=829.

So this is basically what I try with no luck. Although I tried many different iterations using nested if statements among other things. I tried putting parentheses around my logic statements and nothing. I'm pulling my hair out.
=COUNTIFS($S$3:$CA$199,>=$A3,$S$3:$CA$199,<=$B3)
For PM my code would look like this.
=COUNTIFS($S$200:$CA$400,>=$A3,$S$200:$CA$400,<=$B3)


As a side note I'd also like to add a 3rd IF scenario of the date, but that is not necessary yet. My code for that looked like this.
=COUNTIFS($S$3:$CA$199,>=$A3,$S$3:$CA$199,<=$B3,$S$1:$CA$1,=E$1)

Also, ideally this code would work for Excel 2003, but I didn't know if I could do what I wanted with that, so I've been playing with Excel 2007.

Any help would be much appreciated.

Yeah, my fault, this should have been excel. Can I move this or does it need to be done by a forum admin?

I suppose the Outlook part is because it involves counting e-mails? :-)

Thread moved

Thanks, that worked perfectly and I was able to add the necessary code/logic to check for day of the week very easily.

If we stick with this long term I'll probably manually switch it to actual time, but I think this was just to take a quick look at what times of the day we get emails.

Thanks again.

Hi

I need help

I have data Column 1: A,B,C,D, A, C,M,
Column 2 : C1,C2, C3, C1, C4, C5,C6
Coumn3: 1,.5, 1, 1,1,1,1
Comumn 4: True, False, True, False, False, False, False

What I want is

If value of Comumn is A, then how to get distict count of values of Colmun 2

Seconldy If the value is A, and Colum is 4: how to get sum of Column3

Can some one help me on this? I need this usig function

Regads
kvsree