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

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?

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?