I need to count the number of occurances that should have occured. The sheet
has different departments that are inspected every week or biweekly and I
need to calculate the number of inspections that should have occured
biweekly. The sheet is basically set up like:
1/1 1/8 1/15 1/22 (1st monday in week)
dept1 weekly X X X
dept2 biweekly X X
dept3 weekly X
dept4 biweekly X X

returns:
Weekly complted 2 0 1 1
Weekly required 2 2 2 2

How can I set this up so that it will give the total number of inspections
that should be done by bi-weekly.

Not exactly sure I fully understand your questions, but I would use different
letter rather than "X", such as "A" means weekly a time, "B" biweekly a time,
then I can use "count" function to count how many "A" and how many "B", that
retun the number of require for times it should be insepcted.

Hope it helps/

Hank

"caj" wrote:

I need to count the number of occurances that should have occured. The sheet
has different departments that are inspected every week or biweekly and I
need to calculate the number of inspections that should have occured
biweekly. The sheet is basically set up like:
1/1 1/8 1/15 1/22 (1st monday in week)
dept1 weekly X X X
dept2 biweekly X X
dept3 weekly X
dept4 biweekly X X

returns:
Weekly complted 2 0 1 1
Weekly required 2 2 2 2

How can I set this up so that it will give the total number of inspections
that should be done by bi-weekly.

Tried that. Still did not get the results that I need. I need it to calculate
the number of occurances and the number of oppurtuines.


"Hank" wrote:

Not exactly sure I fully understand your questions, but I would use different
letter rather than "X", such as "A" means weekly a time, "B" biweekly a time,
then I can use "count" function to count how many "A" and how many "B", that
retun the number of require for times it should be insepcted.

Hope it helps/

Hank

"caj" wrote:

I need to count the number of occurances that should have occured. The sheet
has different departments that are inspected every week or biweekly and I
need to calculate the number of inspections that should have occured
biweekly. The sheet is basically set up like:
1/1 1/8 1/15 1/22 (1st monday in week)
dept1 weekly X X X
dept2 biweekly X X
dept3 weekly X
dept4 biweekly X X

returns:
Weekly complted 2 0 1 1
Weekly required 2 2 2 2

How can I set this up so that it will give the total number of inspections
that should be done by bi-weekly.