Frequency within date range

C

cursednomore

I have a worksheet that tracks individual sales on a daily basis. I need to
be able to use the frequency function to count the number of sales within
ranges(<350, 350-375, 376-400, etc.) and group these by date, preferably by
week, but if I can do the by date, I can get the week part. Is there an easy
way to accomplish this?

Thanks in advance for any guidance you can provide.
 
M

Myrna Larson

Have you considered a pivot table, with the sales in, say, the rows, the dates
in, say, the columns, and the Count of Sales in the data area? Group the dates
by week and the sales by 25.
 
C

cursednomore

Thanks, Myrna!! It worked like a charm! I never thought about grouping the
sales like you would the dates.
 
Top