how can i subtotal on a text value - ex. every Monday?

J

Jake

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!
 
R

Ron Coderre

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:
Data>Subtotals

I hope that helps.

Regards,
Ron
 
Top