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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

I hope that helps.

Regards,
Ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Sumproduct Ignore Text 2
Subtotals and Conditional Formatting 1
need help on either doing a loop and counting specific values orusing subtotal function 2
Need Text columns to pull into subtotal lines 7
Subtotal of values in cells containing formula 1
Average of Day and Time 3
Need formula to return next Monday's date 4

Back
Top