| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error when using Indirect
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error when using Indirect
hi
=sum(f11:indirect("F"&11+d3-1)) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "dragea" escreveu: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error when using Indirect
this seems to work
=SUM(INDIRECT("f1:f"&11+D3-1)) -- Don Guillett SalesAid Software "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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error when using Indirect
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error when using Indirect
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error when using Indirect
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 different INDIRECT data validation lists from one | Excel Discussion (Misc queries) | |||
| Copying a formulae down a column that includes an INDIRECT | Excel Discussion (Misc queries) | |||
| Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
Linear Mode
