Question:

Hi. I have a spreadsheets with weekdays and arrival times of flights. I want to get a flight distribution?

by  |  earlier

0 LIKES UnLike

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:

   Report
SIMILAR QUESTIONS
CAN YOU ANSWER?

Question Stats

Latest activity: earlier.
This question has 0 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.