if I want to do a summary page of a forecast and put the answers in a date column what would it be now I've got IF(D3=DATEVALUE("7/1/2009"),C3,0) for instance if salesperson A is closing a deal in july 09, post the value of that transaction on a summary page

What value is in C3? "So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown

If what you are trying to do is put the formula on (for example) Sheet 1 but base the result on cells on (for example) Sheet 2, then the formula on Sheet 1 should look like this: =IF(Sheet2!D3=DATEVALUE("7/1/2009"),Sheet2!C3,0) If the Sheets have names, then it might look a little different. On your Sheet named Summary, you might refer to the sheet named Salesperson A as follows: =IF('Salesperson A'!D3=DATEVALUE("7/1/2009"),'Salesperson A'!C3,0)