Forum Discussion

SubhasisB's avatar
SubhasisB
Copper Contributor
Jun 25, 2024

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

 

    • SubhasisB's avatar
      SubhasisB
      Copper Contributor
      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.

Resources