MAXIF function?

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

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
 
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
 
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
 
Back
Top