Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
Subtotal seem slower in Excel 2003 | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
in excel totaling weekly hours military time | Excel Worksheet Functions |