| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges in Functions
hi all,
I am using the following function to get a year-to-date value: =SUMPRODUCT(--('Daily Reading Master Log'!B$3:B$375=DATEVALUE("01/01")),--('Daily Reading Master Log'!B$3:B$375<=DATEVALUE("10/31")),'Daily Reading Master Log'!AD$3:AD$375) This works great when i specify a given date. I want to replace the second date in this array with a Named Range called rptDate. When i try to do this, i get an error. Can I do this, and if so, what do i need to do? -- Carlee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named Ranges in Functions
If the value in rptDate is a date (rather than a Text string):
=SUMPRODUCT(--('Daily Reading Master Log'!B$3:B$375=DATEVALUE("01/01")),--('Daily Reading Master Log'!B$3:B$375<=rptDate),'Daily Reading Master Log'!AD$3:AD$375) In article , Carlee wrote: hi all, I am using the following function to get a year-to-date value: =SUMPRODUCT(--('Daily Reading Master Log'!B$3:B$375=DATEVALUE("01/01")),--('Daily Reading Master Log'!B$3:B$375<=DATEVALUE("10/31")),'Daily Reading Master Log'!AD$3:AD$375) This works great when i specify a given date. I want to replace the second date in this array with a Named Range called rptDate. When i try to do this, i get an error. Can I do this, and if so, what do i need to do? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named Ranges in Functions
Marvellous!!! Thank you so much!
-- Carlee "JE McGimpsey" wrote: If the value in rptDate is a date (rather than a Text string): =SUMPRODUCT(--('Daily Reading Master Log'!B$3:B$375=DATEVALUE("01/01")),--('Daily Reading Master Log'!B$3:B$375<=rptDate),'Daily Reading Master Log'!AD$3:AD$375) In article , Carlee wrote: hi all, I am using the following function to get a year-to-date value: =SUMPRODUCT(--('Daily Reading Master Log'!B$3:B$375=DATEVALUE("01/01")),--('Daily Reading Master Log'!B$3:B$375<=DATEVALUE("10/31")),'Daily Reading Master Log'!AD$3:AD$375) This works great when i specify a given date. I want to replace the second date in this array with a Named Range called rptDate. When i try to do this, i get an error. Can I do this, and if so, what do i need to do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use OFFSET and COUNT functions within Named Ranges | Excel Discussion (Misc queries) | |||
| Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
| Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
| using relative named ranges directly in functions | Excel Programming | |||
| named ranges - changing ranges with month selected | Excel Programming | |||
Linear Mode
