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! |
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 |
All times are GMT +1. The time now is 09:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com