Can you provide a sample of the data, along with the actual/expected
results?

In article <667be0932f52d@uwe, "rhwong" <u26788@uwe wrote:

I have an attendance roster for the month and want to count the number of
absences. The problem I am having is that I can only count 5 consecutive
absences at one time. They can have 7 consecutive absences for one period and
then another set of absences for 5 days. That totals to 10 allowed absences
and 2 unallowed absences. How would you run a function to do this calculation
automatically.