Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell references in SUMIF formulas
Hi,
I'm trying to create a timesheet for myself in Excel. At the top of the sheet is a table with a cell for each day of the month, all with an empty cell next to them. Below this, is an area for entering job details, including the date of the job and its duration in hours. In the empty cell next to each date, I want to put a formula which says: "check the date column below, if the date corresponds to that in the cell to your left, add the numbers of hours noted on that line to this day's total". At the moment, my formula looks like this: =SUMIF($A$14:$A$71,"&B4",$F$14:$F$71) If I take the ,"&B4" reference out and simply insert the relevant date, the formula works fine. But I don't want to manually enter the date every time I create a new page (for a new month). I want this to be a formula that's robust enough to be copied and pasted. Can anyone tell me where I'm going wrong. Many thanks Karl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dragging Cell References/Formulas | Excel Worksheet Functions | |||
SumIf function with Multiple cell references | Excel Worksheet Functions | |||
Cell references in formulas become text | Excel Discussion (Misc queries) | |||
Formulas within Cell References | Excel Discussion (Misc queries) | |||
Sumif function with remote cell references | Excel Worksheet Functions |