Excel 2007 : Issue with MAX function if cell contains text

[mamady]

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

[daddylonglegs]

MAX needs to the "outside" function - I'd use this formula in I9

=MAX(IF(ISNUMBER(SEARCH(I$10,$B$7:$B$3173)),IF($A$7:$A$3173=$G3, IF($D$7:$D$3173=$G$9,$C$7:$C$3173))))

confirmed with CTRL+SHIFT+ENTER and copied down to I13

[mamady]

Great, thank you very much. It works, however, when I drag the formula down, only the results for first two carriers are showing, and 0 for the rest, although the reference text is there in the range!
(0 results for TATA, GTS and Batelco)

any thoughts dear?

[mamady]

no worries dear, I just discovered my mistake

the formula works great

thank you again