Excel Formula- Use Cell Result as Table Name in Formula 1

[Horstt]

I think this is not a difficult thing to do but it is not occuring to me.... I want to insert the result of a cell value as the table name in the following formula.

I am just getting the number of records that fall between to dates.

=SUM(NOT(ISBLANK('2005'!$B$2:$B$1004))*('2005'!$H$2:$H$1004>=$B1)* ('2005'!$H$2:$H$1004<=$C1) )

I have worksheets for each year and was hoping to use one formula in a summary sheet to calculate volumes by month and Qtr.

Cells b1 and c1 in the current worksheet have dates.

 

[SkipVought]

Hi,

If A1 has your range name then INDIRECT(A1) is how you can use it.

BTW, it is a oft made fundamental mistake by spreadsheet users to SEGMENT data into separae sheets or workbooks as you have done "...worksheets for each year...". Your task would be MUCH simpler AND you would be able to glean SO MUCH MORE information from your data, if all your data were in a single table.

Skip,

_{[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie!}