Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 04:37:33 +0000
Post From: Count number of long entries #CREF circular reference error
| [2018-03-09 02:40:50] |
| User701453 - Posts: 176 |
|
Its working was in regard to the syntax error in P3 being removed. After running the following code in P3. =IF(OR(M3,$H$35<>0),0,IF(AND(K3,$J$8=0),P4+1,P4)) The code doesn't count the first trade entry, so i will try to figure out why. I may just adjust the max limit number and move on to the next task. I did a full reboot and the #CREF! error issue hasn't shown back up yet. So hopefully it wont. Thanks again for all your assistance. Much appreciated. Date Time Of Last Edit: 2018-03-09 11:19:36
|