ExcelBanter - Is it possible to have a function like Sumif but for averages

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Is it possible to have a function like Sumif but for averages (https://www.excelbanter.com/excel-discussion-misc-queries/191426-possible-have-function-like-sumif-but-averages.html)

Engineering Accountant

Is it possible to have a function like Sumif but for averages

I need to average a set of numbers if they meet a criteria like sumif for
averages.

Does anybody have a function I could use.

Dave Peterson

Is it possible to have a function like Sumif but for averages

How about using:

=sumif()/countif()

Engineering Accountant wrote:

I need to average a set of numbers if they meet a criteria like sumif for
averages.

Does anybody have a function I could use.

--

Dave Peterson

All times are GMT +1. The time now is 10:29 AM.