plase help me

T

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.
 
B

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)
 
T

tzveti

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

Paul Lautman

tzveti said:
10x but excel undersood "c1" i "c50" like addresses of cells in the
sheet where I type the formula:(
Click to expand...

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

tzveti

:confused: 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
???:confused:
 
Top