SOLVED

Index Match to get Avg. price of a period

Copper Contributor

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

@SubhasisB 

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.

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

@SubhasisB 

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

 

1 best response

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

@SubhasisB 

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

 

View solution in original post