I do use the filter for ad hoc analysis. However, I want to 'list' the
answer (plus many others) to another area for static charts using dynamic
data. The extra time is ok with me as I have many reports that run
weekly/monthly using this data already.

thx,
casey

"T. Valko" wrote:

I have several thousand rows

Any formula solution for that many rows will be slow to calculate. Have you
considered using a filter?

--
Biff
Microsoft Excel MVP


"casey" wrote in message
...
Sample data:

ColA ColB ColC
Row1 22 1/16/2009 55
Row2 23 1/18/2009 17
Row3 22 1/20/2009 33
Row4 25 1/23/2009 9

I have several thousand rows with every column a named range, i.e. rng1,
rng2, etc.

Example: I want to return '55' and '33' from ColC, based on '22' from ColA
between the dates 1/1/2009 and 1/31/2009 (ColB).

Thx,
casey