# AverageIfs - Multiple Criteria 1 Column

1. ## AverageIfs - Multiple Criteria 1 Column

Hi,

I need to do an average of multiple days in an extension of Averageifs formula. How do i go about selecting the multiple days.

Example:

Data has line items with Days mentioned in 1 of the columns.
I need to get an average of (Mon-Thu, Mon-Tue, Sat-Sun) in the output sheet ... Kindly assist

The current formula is

=AVERAGEIFS(Sheet1!\$I\$2:\$I\$14440,Sheet1!\$J\$2:\$J\$14440,">="&Sheet3!E6,Sheet1!\$K\$2:\$K\$14440,"<"&Sheet3!F6,Sheet1!\$D\$2:\$D\$14440,"=????what do i mention here to get the average of desired day????????")

2. Hello joamon,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

3. ## Re: AverageIfs - Multiple Criteria 1 Column

how can the date automatically change during printing

4. ## Re: AverageIfs - Multiple Criteria 1 Column

Hello joamon and Masud Reza Rasel. Welcome to Excel Forum.
This forum is for introductions.
@joamon, please start a new thread to ask your question in the Formulas and Functions forum.
@Masud, please read the forum rules about posting a question in an existing thread, then start a new thread to ask your question in the General forum (also provide details of the issue).
Let us know if you have any questions.

##### Users Browsing this Thread

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