Need help with formulas over different sheets

J

Jakkov

Hello,

I need to know how I can change the numbers of this formula without
changing manually each month:

=SUMAR.SI(Diario!B2989:B3004;Diario!$T$22;Diario!L2989:L3004)

For example this month I´ll go from B3005:B3300, the thing is, this is
a big sheet and I need to change for every column, I tried to put the
values in a cell but excel can´t take it.

What I want is to put the range values in a cell and then change for
all the working cells.


Thanks a lot.
 
F

Frank Kabel

Hi
not sure how this formula is named in your language but
use the function
INDIRECT
for this
 
J

Jakkov

Frank,

Thanks a lot for your help and don´t worry about the language.

I still stuck in finding a solution, when I see the formula:

=SUMAR.SI(Diario!B2989:B3004;Diario!$T$22;Diario!L2989:L3004)

And I try to mix with the indirect one I can´t.

I´ll expalin again, every month I need to change all the cells of a
row, until now I had to do manually, example change B2989:B3004 to
B3050:B3010. What I want is to have a row with the values and change
there the ranges and automatically changes all the rows.

I need a solution of what I need to specify in the formula
=SUMAR.SI(Diario!B2989:B3004;Diario!$T$22;Diario!L2989:L3004)

Thanks!!!
 
F

Frank Kabel

Hi
o.k. lets try. Assume that A1 stores the starting row number and B1 the
ending row number. One way:

=SUMAR.SI(INDIRECT("'Diario'!B" & A1 & ":B" &
B1);Diario!$T$22;INDIRECT("'Diario'!L" & A1 & ":L" & B1))

Replace INDIRECT with your local function name
 
Top