Hi All,
Could someone please help me in getting the sum of records attached in the file week wise.
I have close to 250 rows of records.I have them all day wise .Please help me in finding sum of records weekwise using any formula or macro.
I have data day-wise .e.g : I have the registrations data from 05-Feb to 27-Jul.I want the data from 05-feb to 11 Feb as 1st week ,12-18 feb as 2nd week and so on.. and value is sum of all registratons in that week
~Shanck
Last edited by shanck; 07-28-2015 at 08:47 AM. Reason: Change in the query
What form of output do you want?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hi All,
Could someone please help me in getting the sum of records attached in the file week wise.
I have close to 250 rows of records.I have them all day wise .Please help me in finding sum of records weekwise using any formula or macro.
I have data day-wise .e.g : I have the registrations data from 05-Feb to 27-Jul.I want the data from 05-feb to 11 Feb as 1st week ,12-18 feb as 2nd week and so on.. and value is sum of all registratons in that week.The output I need is just the sum in number.
In the form of a list? Or a row? Or what?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks