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?
|