Hi,
In column A I have a list of sequential daily working day dates, with associated numerical data for each date in column B. Column C contains the day of the week for each date.
On each Friday I would like to sum the data (in column B) of the following 5 working days (i.e. Monday to Friday of the following week)
Can someone please suggest a formula that will accomplish this.
Thanks!
This sums the previous days if the cell is Friday:
Please Login or Register to view this content.
May be this?
Last edited by oldchippy; 11-05-2008 at 11:32 AM.
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks