Reference a Sheet in Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
=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)
 
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)
 
Back
Top