I've pasted a formula which I use to find the piece of work which took longest to complete for each month.

I now need to add on cases with Status C which is found in column F. I cant quite get it to work. I know it needs to be entered using shift+ctrl+enter.

=MAX(IF(MONTH(PA!$A$2:$A$3000)=6,IF(YEAR(PA!$A$2:$A$3000)=2007,(PA!$K$2:$K$3000))))

So in there I need IF(PA!$F$2:$F$3000="C").

Thanks