Support Board

Date/Time: Sat, 18 May 2024 06:22:40 +0000

Post From: Count number of long entries #CREF circular reference error

[2018-03-08 14:33:45] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
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