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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas across columns 2
How do I calculate a weighted average and exclude the empthy cells 2
Sumproduct in matrix means 3
Avoiding auxiliary cells 0
Function help needed please. 3
Help requested for nested conditional formulas referencing other c 3
COUNTIFS ? 1
How do I not count cells that have formulas in them 2

Top