|
|
#5
03-03-2012, 01:58 AM
|
||||
|
||||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Vlookup & IF together | thelauncher | Excel | 5 | 08-25-2013 11:32 PM |
| Vlookup | ibrahimaa | Excel | 8 | 01-03-2012 09:32 PM |
 Can i do this with a VLookup?
|
foodstudent | Excel | 1 | 01-21-2011 12:34 AM |
| Using IF & VLOOKUP together | junction | Excel | 7 | 11-18-2010 05:15 AM |
| Help with VLOOKUP | sakhtar | Excel | 2 | 07-24-2010 07:39 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode