SUMIF that will divide by total instances found

[brooksc29]

This is going to sound confusing, but I'm trying to say if the name in COL B, matches the name in GRAPH!AF$3, then sum the totals in COL J and divide that by the total number of instances you counted the name in COL B.


=IFERROR(SUMIF(B$3:B3,GRAPH!AF$3,J$3:J3)/ ??


I have the first part of the formula, but I'm not sure what the denominator is.

Thanks in advance!

 

[barry houdini]

You can use AVERAGEIF

=AVERAGEIF(B$3:B3,GRAPH!AF$3,J$3:J3)

 

[brooksc29]

is there a way to do it the other way, b/c when applying it down the column, the final result is just off the actual number it's supposed to be

 

[barry houdini]

Well you can use SUMIF/COUNTIF but the result should be the same unless you have blanks in column J where the criterion is matched in B. That way would be just

=SUMIF(B$3:B3,GRAPH!AF$3,J$3:J3)/COUNTIF(B$3:B3,GRAPH!AF$3)