count data in another column ie: E6:E26.

What exactly do you want to count in that column? Cells that are not empty?

Try this...

Use cells to hold your date boundaries:

A6 = lower date boundary
B6 = upper date boundary

Then:

=SUMPRODUCT(--(C6:C26=A6),--(C6:C26<=B6),--(E6:E26<""))

--
Biff
Microsoft Excel MVP


"rsqrn" wrote in message
...
Help,

I'm trying to create a tracking form with a column filled with dates ie:
C6:C26 I would like to look for a range of dates by quarter and count data
in
another column ie: E6:E26. I can't seem to set a date range in the C
column
and get it to count. I'm a novice so please be gentle.

Thanks,
Frank