You're welcome. Thanks for the feedback!

Biff

"dragea" wrote in message
...
Thank you so much. This worked great!

"Biff" wrote:

Maybe this:

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

If D3 is empty the entire range will be calculated.

Biff

"dragea" wrote in message
...
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.