Forum Discussion
Solved
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 i...
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.
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.