View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MJKelly MJKelly is offline
external usenet poster
 
Posts: 114
Default Countif based on two criteria

Thanks, but it's not having the desired effect.

Mon Tue Wed 06:00 06:10 06:20
Y Y Y PM PM PM
Y Y PM XD PM


The above should result in a table displaying monday data as follows

06:00 06:10 06:20
PM 2 1 2
XD 0 1 0

Hope this sheds some light?
Matt