SOLVED

# Index Match to get Avg. price of a period

Copper Contributor

# Index Match to get Avg. price of a period

Hello All,

Hope you are doing well.

May I ask for a little help from you, actually I have daywise sales units in upper table of the attached sheet and price per unit in the second table, there is a dropdown in cell AH2 & AI2 where units sold appears in within a date range.

Pls help me to get the avg. price of that units sold of the same date range in column AJ row no 12 to 17.

Requesting you to pls help me in this, will wait for your reply.

Thanks & Regards,

Subhasis

3 Replies

# Re: Index Match to get Avg. price of a period

In AJ17:

=AVERAGE(INDEX(\$B12:\$AE12,MATCH(\$AH\$2,\$B\$2:\$AE\$2)):INDEX(\$B12:\$AE12,MATCH(\$AI\$2,\$B\$2:\$AE\$2)))

Fill down.

# Re: Index Match to get Avg. price of a period

Sir, thanks for the response.
Actually I want this as price of the given period like price in the selected period.
Like : =SUMPRODUCT(Q12:U12,Q3:U3)/AJ3 for period 16 to 20th in a dynamic way through the selection in dropdown.
Pls can you help me in this.
best response confirmed by SubhasisB (Copper Contributor)
Solution

# Re: Index Match to get Avg. price of a period

Please find the attached file. Formulas are written in yellow cells.

1 best response

Accepted Solutions
best response confirmed by SubhasisB (Copper Contributor)
Solution

# Re: Index Match to get Avg. price of a period

Please find the attached file. Formulas are written in yellow cells.