help with function

[Guest]

Can anyone help me with this issue?

I posted this in general but noone is there today.

I need <b>THE AVERAGE IF</b>

average if Column A contains DFW and F >0, then I need G to = Bob
average if column A contains AUS and F > 0, then I need G to = Lynette
so on so on so on. And there will be approx 300 If's.

 

[Guest]

You can create an AVERAGE(IF(...)) function via an array formula. See here
for a detailed explanation: http://www.mrexcel.com/tip011.shtml

Dave