formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
 
You must log in or register to reply here.

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
Excel Need Countifs Formula Help 0
Help requested for nested conditional formulas referencing other c 3
Function help needed please. 3
Sumproduct in matrix means 3
Countif 2
Condense data for stock ordering 4

Back
Top