slight change in Bob's formula

=SUMPRODUCT(SUMIF(INDIRECT("sheet"&ROW(INDIRECT("1 :31"))
&"!"&"A1:A10"),"john",INDIRECT("sheet"&ROW(INDIREC T("1:31"))
&"!"&"B1:B10")))


On Feb 12, 1:56*pm, puiuluipui
wrote:
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?