Reference a Sheet in Formula

[Carlee]

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)

 

[Bob Phillips]

=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]

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

 

[Bob Phillips]

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)