You are trying to mix a Frequency formula with other logic, which is
difficult in one step.
If nothing else helpes, I would suggest massaging your data a bit to make it
easier to review - indeed through a pivot table.
To do that, you need to convert the dates into a date that shows the week
that it falls in. For example =A2-WEEKDAY(A2). Enter this in column C, and
column C will show the first day of the week that the data comes from

You do not show how your date is derived - is this available in the data or
do you need to calculate it. Use a bit of imagination to standardise your
data into something that you can use to count. Look at the FREQUENCY formula
as it might be able to assist.

Once the data is standardised, you might want to use a Pivot.

rdwj

"Jamie W" wrote:

Hi All,

Currently, I'm trying to set up a data table for records which, once it
works, should resemble the following:

Entered Received
0-30 31-60 61-90 90 0-30 31-60 61-90 90
-----------------------------------------------------
7/27/2007 |35 | 192 | 21 | 20 | 15 | 45 | 38 | 12
8/3/2007 (etc)---
The rows correspond to dates set one week apart, while the columns are
broken down to four attributes (E, R, I) each with four "age" classficiations
(0-30 days and so on, as noted). All the data that will ultimately populate
this table comes from another sheet which has a couple thousand rows of data
with corresponding text values and dates. (IE: 6/28/2007 | Entered |, or
6/29/2007 | Received, where "|" delineates column breaks for the purpose of
demonstration.)

How would I go about creating either an array formula or even using a
PivotTable to count any rows from the data sheet which have a date that's,
say, 30 days or less from the date corresponding to the row as shown in the
first example AND has a certain text value as well?

Kinda confusing, I know. If I was doing this in SQL it'd be cake, but
Excel's not so friendly for the purpose. Basically, here's the goal in
relative terms... let's say I have a bunch of customers returning any bad
apples, and the process flow dictates that the return request goes from
Entered to Received to Inspected. I'm trying to determine how many apples
are in each state and for how long in relation to the date I have showing for
each row.

ANY help would be greatly appreciated, I've been spending the last hour or
so trying to figure this out without any luck.

Thanks,

Jamie