| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to reference two cells to construct formula
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to reference two cells to construct formula
=DCOUNT(INDIRECT("'" & A1 &"'!" & A2........etc
Gord Dibben MS Excel MVP On Sat, 13 Jun 2009 17:09:25 -0700 (PDT), DaisyGirl wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference blank cells in formula | Excel Discussion (Misc queries) | |||
| How to Construct a Formula Based on Text In Changing Cell | Excel Programming | |||
| Construct address as a reference not "text" | Excel Worksheet Functions | |||
| Construct cell reference for use in formula | Excel Worksheet Functions | |||
| How construct a formula from cells with formulas as text? | Excel Programming | |||
Linear Mode
