Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can i subtotal on a text value - ex. every Monday?
I'm looking to subtotal a weeks worth of data every time i hit "Monday". Is
there a way to break on a text value? thanks! |
#2
|
|||
|
|||
If you can put a column in your data list that calcs the week number you
could use this formula: =WEEKNUM(B1,2) That function tells you what week of the year the date is in. In this case the 2 in the forumula tells the function that my weeks begin on Mondays. Then you could just use Excels automatic subtotals to put the subtotals in for you: DataSubtotals I hope that helps. Regards, Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Why is my text changing to pound signs? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |