TFCJamieFay
Active Member
- Joined
- Oct 3, 2007
- Messages
- 480
Hi All,
I'm having problems with a formula that, until this morning, has worked for months! I have used the error checking tools in Excel, but to no avail. Can anyone help please?
This is my formula (the value of A6 is "01/03/2009" which is in the same format as Sheet1, column A)...
...However, when I remove the part that looks for "Accept" it works...
...I don't understand!
Any help would be greatly appriciated!
Jay
I'm having problems with a formula that, until this morning, has worked for months! I have used the error checking tools in Excel, but to no avail. Can anyone help please?
This is my formula (the value of A6 is "01/03/2009" which is in the same format as Sheet1, column A)...
Code:
=SUMPRODUCT(--('[Daily Tracking 2009.xls]Sheet1'!$A$2:$A$10000-DAY('[Daily Tracking 2009.xls]Sheet1'!$A$2:$A$10000)+1=$A$6),--('[Daily Tracking 2009.xls]Sheet1'!$I$2:$I$10000="Accept"))
...However, when I remove the part that looks for "Accept" it works...
Code:
=SUMPRODUCT(--('[Daily Tracking 2009.xls]Sheet1'!$A$2:$A$10000-DAY('[Daily Tracking 2009.xls]Sheet1'!$A$2:$A$10000)+1=$A$6))
Any help would be greatly appriciated!
Jay