S
smcmoran
Need to count a row if the date formatted as dddd is X (Monday). imported
date format is 1/10/2009 8:46:00 AM and then formated. On another sheet i
need to count how many times a row has "Friday". ex. =COUNTIF('US WW
011009'!J:J,"Saturday")
then I need to be able to average a result valuse from the first sheet "IF"
a valuse of Friday is in the row. So the columns contain the result of a
simple =H4-G4. I then need to averge the I:I IF J:J = Friday.
Any ideas?
date format is 1/10/2009 8:46:00 AM and then formated. On another sheet i
need to count how many times a row has "Friday". ex. =COUNTIF('US WW
011009'!J:J,"Saturday")
then I need to be able to average a result valuse from the first sheet "IF"
a valuse of Friday is in the row. So the columns contain the result of a
simple =H4-G4. I then need to averge the I:I IF J:J = Friday.
Any ideas?