MAXIF function?

[Daniel Bonallack]

In column B I have names of sales people, and in column C
I have their sales. How can I return the maximum sales
for sales rep Jack?

Thanks
Daniel

 

[Dan E]

Daniel,

=MAX((B1:B100="Jack")*(C1:C100))

array entered (control + shift + enter)
{ } will appear around the formula if it array enters
{=MAX((B1:B100="Jack")*(C1:C100))}

Dan E

 

[Peo Sjoblom]

One way

=MAX(IF($A$4:$A$200=H1,$B$4:$B$200))

entered with ctrl + shift & enter

where H1 holds Jack, H4:H200 holds the sales reps and B4:B200 their sales