Support Board
Date/Time: Sun, 19 Jan 2025 03:07:49 +0000
Post From: Count number of long entries #CREF circular reference error
| [2018-03-08 14:33:45] |
| Sawtooth - Posts: 4154 |
|
Try this: P3: =IF(OR(M3,$H$35<>0),0,IF(AND(K3,$J$8=0),P4+1,P4)) K3: =AND($J$8=0,ID38.SG1@3<>0,P4<2) In this situation: -You don't need to use absolute references of Formula Column cells. -You need to reference row 4 to avoid a #CREF error. -The zeroing IF needs to precede the incrementing IF. Date Time Of Last Edit: 2018-03-08 16:05:39
|