Forum Discussion
find cost per 1000 impressions over first 10 days
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.
HansVogelaar 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