In column A I have weekdays (from 1-Sunday- to 7-Saturday). In column B I have different arrival times of flights, from hour 0000 to hour 2459. I want to count how many flights I have, for instance, on the 0800 to 0859 bank on Sunday, and the same for each day of the week and each hour bank. I have tried countif, and many other statements, but it will not let me do it.
I tried te following:
=COUNTIF(A1:A1956,AND($A$1:$A$1956="1"...
I think one of the problems is that the flight arrival times are formatted as text (i have a macro that gets this info from another file), and even if i change the format, I don't think that excel is recognizing the >= or <= statements.
Can anyone help me with this?
thank you very much!
Mercedes
Tags: