Frequency within date range
 

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.

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.

On Mon, 12 Sep 2005 10:42:01 -0700, cursednomore
wrote:

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.

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

"Myrna Larson" wrote:

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.

On Mon, 12 Sep 2005 10:42:01 -0700, cursednomore
wrote:

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.