Error when using Indirect

[Guest]

I am using the following function in one spreadsheet but when I copy it to a
different spreadsheet I get the #value! error.

=SUM(INDIRECT("$F$11:$F$"&(11+D3)-1))

Can anyone help? I want to only sum a certain number of rows based on what
month it is. I have the month in cell D3 and my data starts in F11. If it
is the 3rd month of the year I want it to sum F11:F13.

 

[Guest]

hi

=sum(f11:indirect("F"&11+d3-1))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"dragea" escreveu:

 

[Don Guillett]

this seems to work
=SUM(INDIRECT("f1:f"&11+D3-1))

 

[Biff]

Maybe this:

=SUM(F11:INDEX(F11:F22,D3))

If D3 is empty the entire range will be calculated.

Biff

 

[Guest]

Thank you so much. This worked great!

Maybe this:

=SUM(F11:INDEX(F11:F22,D3))

If D3 is empty the entire range will be calculated.

Biff

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Thank you so much. This worked great!