it's a huge work. I have 1-15 names in every sheet and the names are random.
it would be easier, but i have diferent names in every sheet.
i need sheet 1 to calculate the sum of john's corespondant cell in every
sheet.

sheet 1
A B

1 john =all sheets (sheet 2.....sheet 31) john's corespondant
cell.

thanks.









"Bob Phillips" a scris:

Then you would be best to put a calculation formula in the same cell in
every sheet, and then sum those cells.

--
__________________________________
HTH

Bob

"puiuluipui" wrote in message
...
Hi, i say it a little bit wrong. John is not every time in A1 and the late
time not allways in B2. my mistake. In sheet 2 could be in row 3 or
9..etc. I
just want the sum of the cell corespondent to John. If John is A3, late
hours
are in B3. if John is in A9, the late hours are in B9. etc....if John is
not
in some sheet, the code to skip that cell and count the cells sheets
containing John. Sorry again.
Can you help me with this onT?
thanks.

i need the code in
"Bob Phillips" a scris:

=SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&ROW(INDIRECT(" 1:31"))&"'!A1"),"John",INDIRECT("'Sheet"&ROW(INDIR ECT("1:31"))&"'!B2")))

--
__________________________________
HTH

Bob

"puiuluipui" wrote in message
...
Hi, i have

if A1=John

sheet 1 sheet 2 sheet 3
....etc
A1=John A1=John A1=John
B2=00:01:29 B2=00:08:41 B2=00:24:04

I need the sum of all the cells corespondent to John
But John is not in every sheet, and i have 31 sheets.
Can this be done?