broncos347
Active Member
- Joined
- Feb 16, 2005
- Messages
- 293
- Office Version
- 365
- Platform
- Windows
I have the following formula;
=SUMPRODUCT(--('All Station Surveys with Type a'!$E$6:$E$2000="submitted"),--('All Station Surveys with Type a'!$G$6:$G$2000="in progress"),--('All Station Surveys with Type a'!$C$6:$C$2000="all"),--('All Station Surveys with Type a'!$D$6:$D$2000>=B5),--('All Station Surveys with Type a'!$D$6:$D$2000<=C5))
and every time I can something in the formula I get an "Unable to Record" message come up when I move away from the cell.
=SUMPRODUCT(--('All Station Surveys with Type a'!$E$6:$E$2000="submitted"),--('All Station Surveys with Type a'!$G$6:$G$2000="in progress"),--('All Station Surveys with Type a'!$C$6:$C$2000="all"),--('All Station Surveys with Type a'!$D$6:$D$2000>=B5),--('All Station Surveys with Type a'!$D$6:$D$2000<=C5))
and every time I can something in the formula I get an "Unable to Record" message come up when I move away from the cell.
