Excel formula

[Guest]

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

 

[Guest]

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?

 

[Guest]

We are counting the number of crews that worked in a month. Sometimes crew 3
will work two shifts in one day. We're not wanting a value of 6. We are
hoping to get the number of days crew 3 worked in a month. Each value to the
right of the dates represent the crew number. So, for instance, crew 3
worked 2 days between 01-01-07/01-03-07. This is the number we're interested
in and not the number of shifts that was worked in a month. I'm sorry I
didn't explain it better earlier.

ta