Excel 2007 : Issue with MAX function if cell contains text

Hi all,

I am trying to initiate a MAX function if the cell contains spcefic text (Mobile vs Fixed)

However I am getting null and False returns!

Below is not functioning well!

{=IF(ISNUMBER(SEARCH("Mobile",$B$7:$B$3173)),MAX($C$7:$C$3173*(($A$7:$A$3173=$G3)*($D$7:$D$3173=H$2))))}

Attached is the spreadsheet I am working on

Appreciate your help

Thanks in advance