Averageifs based on row range(multiple dates) and matching column range.

[fusion5151]

Hi,

I'm looking to build a formula to average a specific date range(row 2) based on a specific matching criteria in the row column A.

In this case once there is an average, i'd like to create a sum so for apples this would be a total of 14.

Also note my date ranges will consciously change so i'd like to adjust based on this criteria.

See below for table.

Start Date

3-Jan​

1-Jan​

2-Jan​

3-Jan​

4-Jan​

5-Jan​

6-Jan​

7-Jan​

8-Jan​

9-Jan​

10-Jan​

Average

End Date

7-Jan​

Apples

5​

10​

5​

8​

5​

2​

3​

7​

8​

7​

5​

Apples

Apples

9​

4​

7​

7​

2​

5​

2​

8​

2​

7​

5​

Orange

Oranges

5​

9​

7​

5​

1​

9​

5​

6​

9​

4​

5​

Tomato

Oranges

5​

3​

1​

2​

5​

1​

2​

3​

4​

4​

2​

Apples

5​

6​

6​

1​

1​

9​

4​

3​

8​

3​

4​

Tomato

3​

1​

7​

6​

4​

10​

4​

8​

5​

4​

6​

Tomato

8​

5​

7​

6​

1​

7​

2​

1​

1​

8​

5​

Thanks for all your help.

Steven

 

[Fluff]

The simplest & most efficient way would be to use

=SUMIFS(M:M,A:A,O3)