Average with 2 variables

**paconovellino** · 11-06-2013, 07:07 PM

Hello,

I have an excel file with 2 sheets. Sheet #1 contains daily data (Mon, Tue, Wed ...) for the past 30 days. Daily data is broken down in 30 minutes interval. On Sheet #2 I need a formula that can average every monday and the time interval.

Please help Im going crazy trying to use a averageifs formula

Im attaching the file im using.

Thanks

**jubiesxl** · 11-06-2013, 07:20 PM

Does Pivoting the data helps.

See attached XLS with Pivoted sheet

**Tony Valko** · 11-06-2013, 07:26 PM

Since the time intervals are the same on both sheets you can use this.

Entered on the Answers sheet in cell B2:

=AVERAGEIF(Sample!$B$1:$V$1,B$1,Sample!$B3:$V3)

Copy across then down as needed.