Alright. I'm using Excel 2003 and as far as i know it doesn't have an AVERAGEIF function. But i could use some help getting an average on certain cells if another cell meets a certain criteria?
For example:
I have a list of drillers in column B with the corresponding well# in column C and corresponding Pump Test Gallons Per Minute in column D.
I have the driller i want to see the averages for in H4.
so i need all of the pump test GPM's averaged if the drillers in column B = H4
So i thought an AVERAGEIF function might work.
I've tried something along the lines of =AVERAGE(IF(B4:B212=H4,D4:D212)) but somethings not right.
Any help would be much appreciated thanks.
Bookmarks