| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula in a sheet reference | Excel Worksheet Functions | |||
| Use cell value as reference to sheet in formula? | Excel Worksheet Functions | |||
| Is it possible to change a Sheet reference in a formula? | Excel Discussion (Misc queries) | |||
| Formula to reference name of sheet tab | Excel Discussion (Misc queries) | |||
| Need formula for sheet & cell reference | Excel Worksheet Functions | |||
Hybrid Mode
