Correction to Formula

[PhilH1982]

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

[daddylonglegs]

Try

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

or a little shorter....

=MAX(IF(TEXT(PA!$A$2:$A$3000,"mmmyy")="Jun07",IF( PA!$F$2:$F$3000="C",PA!$K$2:$K$3000)))

[PhilH1982]

Cheers.

Looking at the formula, I was putting a close bracket in the wrong place and thats why I couldnt get mine to work. I was close enough

Thanks again