Hi,

I want to count the numbers of cells with a certain value in it, in a range
which starts and ends based on the current date.

I have this list of attendence: For every person we register if they were at
training or game: training are on wednesday and friday, games sometimes on
saturday. For each 'appointment' (training/games-) we have a column. For
each player we have a row. If they were at training, we put "1", if they
weren't but they warned us we put a "v", and if we didn't get any news at
all we put nothing in it.

5-08 7-08 12-08 14-08 19-08 21-08
PEOPLE AUGUST
person 1 1 v v 1 v 1
person 2 v v v 1 1
person 3 1 v 1 1 1 1
person 4 1 v 1 v v


Now I want to know for each person how many times they were there, howm any
times they warned, and how many times they weren't there without warning;
and this for the last 10 appointments. So I have to select a range based on
the current date, and based on the values in the first row, and than perform
a countif on it.

Anybody has any idea how to get to this range? I don't find a formula (or
combination of some of them) which helps me with this :-/ Preferably, this
also should work in Google Docs :-)

Thanks a lot in advance,


Pieter