plase help me

[tzveti]

Hi,
I want to ask if it is possible to sum numbers from different sheets
but with the same addresses. For example if i have 50 sheets in one
warkbook may i sum numbers from 5 of them. These five have the same
name in one cell - for example KAI(A3) and a number in other cell with
address (h31). I want to make a formula which extract only this 5 sheets
with name KAi and sum numbers from cells with address h31.
Thanks in advance
Excuse me for my bad eng.

 

[Bob Phillips]

Put the sheet names, all of them, in C1:C50, and use

=SUMPRODUCT(SUMIF(INDIRECT("'"&C1:C50&"'!A3"),"KAI",INDIRECT("'"&C1:C50&"'!H
31")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[tzveti]

10x but excel undersood "c1" i "c50" like addresses of cells in th
sheet where I type the formula:

 

[Paul Lautman]

10x but excel undersood "c1" i "c50" like addresses of cells in the
sheet where I type the formula

Could you try this again, it doesn't seem to make any sense???

 

[tzveti]

It didn't work. There was an error in the formula. And when I
begin to write some constant like the name kai Excel marked the cells in
the sheet from c1 till c50 I cannot understand what is wrong
???