| 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 |
| 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 | |||
Threaded Mode
