Weekly Subtotal in Excel
I am working with a spreadsheet that has detailed history of various
financial transactions occuring during a workweek only. Column A is the date in day form ('Wednesday', etc.), Column B is the date in date form ('3/7/06'), and Columns C through F are various types of expenses. Column G gives a total of C through F for each day. Okay, that's all well and good. My problem is with Column H in which I would like to show a weekly total of everything from Monday through Friday, and on weeks when Friday is not a workday, Monday through Thursday. I'd like this to only display on Fridays or Thursdays. Is there a way to do a subtotal that will recognize a different workweek and display a total? For that matter, a different month and year, too? Thanks! |
All times are GMT +1. The time now is 01:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com