Conditional Average

[santhoshkunder]

How to achieve conditional average. I need average wherever there is "D" , When there is no "D" then it has to calculate the average for "R1".

Thanks
santhosha'

 

[Eloise T]

The following short explanation in conditional averaging was written by Susan Harkins...someone I've found to be a good resource:

http://www.techrepublic.com/blog/windows-and-office/two-ways-to-find-a-conditional-average-in-excel/

 

[Chihiro]

Something like this?
=IFERROR(AVERAGEIF(B19:B21,"D",C19:C21),AVERAGEIF(B19:B21,"R1",C19:C21))

 

[santhoshkunder]

Something like this?
=IFERROR(AVERAGEIF(B19:B21,"D",C19:C21),AVERAGEIF(B19:B21,"R1",C19:C21))

Amazing. It worked!. Thanks

 

[NARAYANK991]

Hi ,

Going by your workbook , you should use the following :

=IFERROR(AVERAGEIFS($C$2:$C$24,$A$2:$A$24,A3,$B$2:$B$24,"D"),AVERAGEIFS($C$2:$C$24,$A$2:$A$24,A3,$B$2:$B$24,"R1"))

so that you do not need to select the range individually for each job code.

Narayan