Create an AVERAGEIF function.

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

Guest

Introduce an AVERAGEIF function in Excel. Can currently do it, but only
combining SUMIF and COUNTIF... clumsy.
 
=AVERAGE(IF(A1:A100=condition,A1:A100))

enter as an array formula, that is commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
If you want something like an average of column C when Column A is a name
Try
=Average(if(A1:A50="name",C1:C50,"") entered as Array (Control Shift Enter)
The Criteria can be almost anything you want it to be.
This also works for Standard deviations etc.
 
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

Sumifs, averageifs, countifs 6
AVERAGEIFS Error 0
AVERAGEIF in pivot tables 1
AVERAGEIF problem 6
Averaging two ranges on the same column (excluding zeros) 2
Average IFS (Multiple Criteria) 1
AVERAGEIF problem 3
Excel AverageIF issue... PLEASE HELP! 1

Back
Top