Named Ranges in Functions

C

Carlee

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

JE McGimpsey

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)
 
C

Carlee

Marvellous!!! Thank you so much!
--
Carlee


JE McGimpsey said:
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)
Click to expand...
 

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

Using SumProduct in Code 2
Desparate..please help 4
function tweak? 5
Date Issue 1
Where no value, display "NA" - if statement? 3
If Statement 1
If Statement 2
COUNTIFS using multiple named ranges in the criteria 0

Top