Excel formula references

[Cheech]

I am currently trying to build a spreadsheet that will build a report off some data.
What I have at the moment is this:

=COUNTA(Data!C4:C27)

The problem is that their are several formula in the reports sheet and the data range will change each time the spreadsheet is used.
Is there any way I can enter the formula range (Data!C4:C27, or whatever it is) in another worksheet and do something like this:

=COUNTA(=Range!A1)

So that all of the formula will take the ref from the Range!A1 cell.

I think that makes sense???

Cheech

[Peace][Pipe]

 

[SkipVought]

Hi,

Check out faq68-1331.

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[AnotherHiggins]

If there is nothing under the values in column C, you could just use:
[tab]=COUNTA(Data!C:C)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.