Problem with AVERAGEIF and Multiple Criteria

  • Thread starter Thread starter Joe Cook
  • Start date Start date
J

Joe Cook

Hi, I've got a problem with the followiing array formula

=AVERAGE(IF(($B$2:$B$99>="JOE")*($J$2:$J$99>=2.01)*($J$2:$J$99<=4),$J$2:$J$99))

Basically Column B has a list of names, JOE being one, Column J has
list of results,

Column B J

JOE 1.52
STAN 2.52
JAMES 9.97


I've set up a table to show the average number of results Joe has for
particular time period, 0.01 to 2.00, then 2.01 to 4.00 all laid out i
seperate columns, but when using the formula to pick up STAN th
result will return an average for the entire list not just the STAN o
JOE specifc values.

Cheers

Davi
 
Hi
try
=AVERAGE(IF(($B$2:$B$99="JOE")*($J$2:$J$99>=2.01)*($J$2:$J$99<=4),$J$2:
$J$99))
 
Back
Top