Hi Marvin,

I think I'm getting this.... Adding the Active and inactive worked great.

For students without points I think I have it: I used the auto filter under the data tab to filter out the months I want. Then in the student tab I used a countif function, it seems to work as long as the range is set to the area that is shown after the filtering.

I'm not able to pick more than one date on my excel. I'm using a mac at home with 2008 (Getting the upgade this weekend) and work is still on 2003. However I think I can use the same procedure and make a new piviot table.

Thanks for you help.

Andy