formula help

G

GTK

I need a formula to average the results in column AB, when thwe results in column B = 2000, and when the results in column D are <60. I tried this with no luck. =AVG((B2:B492=2000),(D2:D492<60),AB:AB492)
 
I

immanuel

Try the following array formula:

=AVERAGE(IF((B2:B492=2000)*(D2:D492<60),AB2:AB492,""))

You'll need to hit Ctrl-Shift-Enter instead of just Enter after pasting or
typing in the formula.

/i.

GTK said:
I need a formula to average the results in column AB, when thwe results in
Click to expand...
column B = 2000, and when the results in column D are <60. I tried this
with no luck. =AVG((B2:B492=2000),(D2:D492<60),AB:AB492)
 
Top