help with function
 

Can anyone help me with this issue?

I posted this in general but noone is there today.

I need <bTHE 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.

help with function
 

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Tammy" wrote:

Can anyone help me with this issue?

I posted this in general but noone is there today.

I need <bTHE 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.