I need to calculate a gross sum of Rating for date wise ad placement, rating will be on next sheet for all days; ie monday, tuesday, wednesday and so on...
table of ads placement will be on another sheet which will consist of dates, frm rating sheet look and match the 'day' & 'timeslot' then divide by 30(its mandatory) and then multiply with spot duration then multiply with number of ads placed that day, finally it adds up the result of all days, but all calculation in a single cell.
Im trying to find solution for couple of days already digged many thread but couldn't find any specific solution.
Kindly help me out...
https://drive.google.com/file/d/0B-TGcQPj4c7KOHZtUkFBa1h3dUU/edit?usp=sharing
table of ads placement will be on another sheet which will consist of dates, frm rating sheet look and match the 'day' & 'timeslot' then divide by 30(its mandatory) and then multiply with spot duration then multiply with number of ads placed that day, finally it adds up the result of all days, but all calculation in a single cell.
Im trying to find solution for couple of days already digged many thread but couldn't find any specific solution.
Kindly help me out...
https://drive.google.com/file/d/0B-TGcQPj4c7KOHZtUkFBa1h3dUU/edit?usp=sharing
