Forum Discussion
Solved
find cost per 1000 impressions over first 10 days
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?
See the attached workbook.
See the attached workbook.
HansVogelaar 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 🙂
Could you attach a sample workbook with dummy data representative of the data you work with?
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.