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
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 Read More