=SUMPRODUCT((TEXT('US WW 011009'!J1:J20,"dddd")="Saturday")*1)

but this is a bit cleaner:

=SUMPRODUCT((WEEKDAY('US WW 011009'!J1:J20)=7)*1)

HTH,
Bernie
MS Excel MVP


"smcmoran" wrote in message
...
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?