Hi,

Your data does not match your stated results.

What are you counting in the range of values? You are counting each item
once on any given date, so if you have 3 dates with items you must have a
minimum of 3 as your total, but you say 2?

--
Thanks,
Shane Devenshire


"Tamra Austin" wrote:

We would like a formula that would count a value once in range of date.
Date Value
01-01-07 3
01-01-07 3
01-01-07 4
01-02-07 1
01-02-07 4
01-02-07 1
01-03-07 3
01-03-07 1
The number is listed twice on 1-1-07; but we would like for it to be counted
a one occuring value for the day (not counting a repeated value). The total
value would be 2 from 01-01-07 to 01-03-07