PDA

View Full Version : Solved: countif problems



KK1966
09-01-2008, 10:26 PM
Hi?

May I have some one help which formulas can count by Time as attached sample COL ?E? to measure with the commitment time at the COL ?C? and wanna count numbers of the stop less than 1 hours at COL I?

Your help I many thanks

KK1966
09-01-2008, 10:28 PM
Sorry to have missing attachment

Bob Phillips
09-02-2008, 02:06 AM
That data is lamentably lacking for us to determine what to do, No times, what is No. of stop, what is Time Zone, etc., etc.

KK1966
09-02-2008, 02:22 AM
Dear XLD
sorry about the message not clear, the no of Stop is that's means " numbers of the stop deivered "
and the time shown at col E' that I chage to decimo.

KK1966
09-02-2008, 02:25 AM
Dear XLd

I has change back to time formats as attached

Bob Phillips
09-02-2008, 02:37 AM
Your two replies have added nothing to what I already ken (didn 't know). You haven't explained anything more, so as yet I can't help.

KK1966
09-02-2008, 03:12 AM
Dear xkd

Actully that's I wanted to count how many company's to have delivered within one hours by COL E" to measuer with COL"C

Thanks ur help

Bob Phillips
09-02-2008, 03:23 AM
=SUMPRODUCT(--(E2:E14-C2:C14<=TIME(1,0,0)))

KK1966
09-02-2008, 03:39 AM
Exactly, thanks very much

Aussiebear
09-12-2008, 02:12 AM
kk1966, see what a clear explanation can get you as a response?

KK1966
09-12-2008, 02:28 AM
hi
Aussiebear, I don't know what kind of you sent and which explanation as you want,

Please let me know if I made any wrongs, and which parts changes are need



KK,
thanks

Aussiebear
09-12-2008, 02:46 AM
Read through the posts you made in this thread. It wasn't until post #7 that you actually indicated what you really needed, then XLD was able to assist you.