CODEWITHSUNDEEP
excel
user5407997
user5407997

Reputation: 21

excel averageifs with date and greater than criteria

I am trying to use the averageifs function in excel to find the average that meets a date criteria and is below three standard deviations. This is what I have

=averageifs(R16:R38375,R16:R38375,"<U19",P16:P38375,U16)

The P column contains the date range and U19 is the date criteria.

I have also tried array functions with no luck. Thank you in advance for the help.

Upvotes: 2

Views: 19415

Answers (1)

user4039065
user4039065

Reputation:

You need to take the less than operator alone in the quotes and concatenate the cell reference off the right end.

    =averageifs(R16:R38375, R16:R38375, "<"&U19, P16:P38375, U16)

AVERAGEIFS function

Upvotes: 5

Related Questions