Hi all,
I have the following columns:
Column A: Unique ID (each component has a unique identifier)
Column B: Occurrence (each row counts an occurrence)
Column C: Date (each occurence has a date associated with it)
Column D: Daily Volume (each occurrence and date has a daily volume figure associated with it)
Column E: Week number (based on date field)
Please see attached example.
In my example the weekly volume for week 8 will be '1538'.
What i am trying to do is: sum the daily volume given for each day and return a value for any particular week number, sound simple right?
Please help, thanks
Bookmarks