I need to calculate a sum of Rating on date wise ad placement, rating will be on next sheet for that day; find and match the 'day' & 'timeslot' then divide by 30(its mandatory) and then multiply with spot duration and count of spot from that day.
See the attached file.
m trying to find solution for couple of days already digged many thread but couldn't find any specific solution.
Kindly help me out...
Bookmarks