Sorry, I missed that you want the average and max as well.
Sum
=SUMIF(B2:B20,"Medical",C2:C20)
Average
=AVERAGEIF(B2:B20,"Medical",C2:C20)
Max (this is an array formula, CTRL+SHIFT+ENTER, not just ENTER)
=MAX(IF(B2:B20="Medical",C2:C20))
However, if you want to repeat this exercise for each division then you should use a pivot table. I have attached an example.
|