Need to reference two cells to construct formula

D

DaisyGirl

Hi

I don't think this is a hard problem but I'm definitely struggling
with it.

This formula currently works:

=DCOUNT('CD-09-147968'!A1:M10, "Date received", Query!C5:D6)


I would like to reference the name of the sheet (CD-09-147968) by
getting the information from another cell. Let's say that this
information will be stored in cell A1.

I also want to put the A1:M10 range in another cell and reference that
as well. Let's say this information will be stored in A2.

Does anyone know how to refer to cells A1 and A2 in the DCount formula
so that it gets the spreadsheet name and cell range?

Thanks for any help you can give....

regards
Helen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Copy addition formula of non-consecutive horizontal cells 2
Can a formula do this? 1
setting one worksheet cell range reference to another worksheet 1
Naming non-contigent cells with vba 5
Macro to create Name Ranges! 1
How do I reference cells in CF formula within loop 2
How to delete ALL cells containing the same data 1

Top