Thread: Count Weekdays and Weekends separate & < a given cell.
View Single Post
  #10   Report Post  
Milo Bloom Milo Bloom is offline
Junior Member
  
Posts: 19
Smile Count Weekday and Weekend
Woo Hoo we have Victory!!

Thanks so much for the help :-)

=SUMPRODUCT((WEEKDAY(A$2:A$32,2)5)*(A2:A32)*D$2:$ D32)/SUMPRODUCT((WEEKDAY(A$2:A$32,2)5)*(A2:A32))
Reply With QuoteReply With Quote