Reference a Sheet in Formula
 

Hi All,

I want to reference 'Daily Reading Log' in the following formula, but keep
getting an error. Where do i need to place the reference?

This formula is actually listed on the 'Summary" sheet, but the data for the
formula comes from teh "Daily Reading Log'


=SUMPRODUCT(--(B3:B18=DATEVALUE("01/03")),--(B3:B18<=DATEVALUE("30/03")),CA3:CA18)


--
Carlee

Reference a Sheet in Formula
 

=SUMPRODUCT(--('Daily Reading Log'!B3:B18=DATEVALUE("01/03")),--('Daily
Reading Log'!B3:B18<=DATEVALUE("30/03")),'Daily Reading Log'!CA3:CA18)



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Carlee" wrote in message
...
Hi All,

I want to reference 'Daily Reading Log' in the following formula, but keep
getting an error. Where do i need to place the reference?

This formula is actually listed on the 'Summary" sheet, but the data for
the
formula comes from teh "Daily Reading Log'


=SUMPRODUCT(--(B3:B18=DATEVALUE("01/03")),--(B3:B18<=DATEVALUE("30/03")),CA3:CA18)


--
Carlee

Reference a Sheet in Formula
 

This worked brilliantly....thank you so much!!!!
--
Carlee


"Bob Phillips" wrote:

=SUMPRODUCT(--('Daily Reading Log'!B3:B18=DATEVALUE("01/03")),--('Daily
Reading Log'!B3:B18<=DATEVALUE("30/03")),'Daily Reading Log'!CA3:CA18)



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Carlee" wrote in message
...
Hi All,

I want to reference 'Daily Reading Log' in the following formula, but keep
getting an error. Where do i need to place the reference?

This formula is actually listed on the 'Summary" sheet, but the data for
the
formula comes from teh "Daily Reading Log'


=SUMPRODUCT(--(B3:B18=DATEVALUE("01/03")),--(B3:B18<=DATEVALUE("30/03")),CA3:CA18)


--
Carlee

Reference a Sheet in Formula
 

So what did you get wrong, was it the single quotes around the name?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Carlee" wrote in message
...
This worked brilliantly....thank you so much!!!!
--
Carlee


"Bob Phillips" wrote:

=SUMPRODUCT(--('Daily Reading Log'!B3:B18=DATEVALUE("01/03")),--('Daily
Reading Log'!B3:B18<=DATEVALUE("30/03")),'Daily Reading Log'!CA3:CA18)



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Carlee" wrote in message
...
Hi All,

I want to reference 'Daily Reading Log' in the following formula, but
keep
getting an error. Where do i need to place the reference?

This formula is actually listed on the 'Summary" sheet, but the data
for
the
formula comes from teh "Daily Reading Log'


=SUMPRODUCT(--(B3:B18=DATEVALUE("01/03")),--(B3:B18<=DATEVALUE("30/03")),CA3:CA18)


--
Carlee