Hi there
I have a problem.

=COUNTIF(INDEX('sh1'!2:2;1;$AI$2):INDEX('sh1'!2:2;1;$AI$3);1)

The above means:
count the value 1 from sheet 'sh1' on row 2 from column numbered AI2 to the column numbered AI3.

I use a validation list (S3 cell) that representing groups (01,02,03,10,15,20 etc), so when i choose a value, the following two functions gives me the range ot the group that the countif function must use.

The first gives me the start column and the second the ending column

{=MIN(IF('sh1'!B2:IV2=S3;COLUMN('sh1'!B2:IV2)))} -->AI2 cell
{=MAX(IF('sh1'!B2:IV2=S3;COLUMN('sh1'!B2:IV2)))} -->AI3 cell

Eg
A----B-----C------D------E--------F-----G----- etc
01---01----01----02-----02----02-----02---- ect --->the groups
0----1------2------0---- etc ---> the values (from 0 to 5)
1---0-------4------3-----etc

Is it possible to make the above to work for 4 worksheets at the same time instead of one, because i have data to all the 4 sheets?

Notice that the S3 value in the validation list that representing groups i

Thanks in advance