find cost per 1000 impressions over first 10 days

[Izzy90]

I have column, with dates on D2:D161, costs on E2:E161, Impressions on F2:F161

What would be the  CPM (cost per 1000 impressions) over the first 10 days?

[#2 · Accepted solution]

@Izzy90 

See the attached workbook.

[#3]

@Hans Vogelaar I am trying to see a cumulative result of cost per 1000 impressions over first 10 days. 

How do I do that? 

Thank you for the excel file though :) 

[#4]

@Izzy90 

Could you attach a sample workbook with dummy data representative of the data you work with?

[#5]

@Hans Vogelaar 

[#6]

@Izzy90 

I see that the dates aren't sorted in ascending order.

Wouldn't it be better to sort them? That looks more logical, and you can then use

=AVERAGE(C2:C11/B2:B11)*1000

But if the data aren't sorted, you can use

=AVERAGE(IF(A2:A16<=SMALL(A2:A16,10),C2:C16/B2:B16,""))*1000

Both have to be confirmed with Ctrl+Shift+Enter.

[#7]

I get both your approaches. Thanks a million Hans

[#8]

@Hans Vogelaar how would you approach the problem if you had duplicate dates. In that case setting range till 10th row will not work. Dummy data in the attachment? 

Thanks in advance 

[#9]

@Izzy90 

Please explain in detail how you want the average to be computed. Do you want to count the first 10 unique dates? And how should the data for duplicate dates be treated?