# AVERAGEIFS to average times in a range if criteria met

1. ## AVERAGEIFS to average times in a range if criteria met

Static table is setup in column A and B. Column A contains Products Origin and column B contains Start Time. Dropdown option in E2. When a region is selected in E2, would like AVERAGEIFS to calculate average time based on Produce Time in C2:C20, Start Time in B2:B20, and time interval range in E5 to E14. Desired result should be in F5:F14.

Sample file attached.

2. ## Re: AVERAGEIFS to average times in a range if criteria met

is this what you are after
=IFERROR(AVERAGEIFS(\$C\$2:\$C\$20,\$A\$2:\$A\$20,\$E\$2,\$B\$2:\$B\$20,">="&E5,\$B\$2:\$B\$20,"<"&E6),"")

so it looks at the time in cell E5 and anything greater than E5 but less that E6 is th erange of times to include in the average

the last entry will be wrong for 2PM as no value in E15
E15 - needed for my average of time - I guess we could just use E14 and add 1 hour

3. ## Re: AVERAGEIFS to average times in a range if criteria met

etaf: works like a charm! Desired solution. Thanks etaf for the solution.

4. ## Re: AVERAGEIFS to average times in a range if criteria met

you are welcome, thanks for the rep

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1