Support Board

Date/Time: Mon, 16 Sep 2024 19:41:43 +0000

Post From: Receiving "#REF!" Error in spreadsheet

[2024-07-13 00:13:49] Link To Thread - Link To Post [Go To First Post]
User827002 - Posts: 36
I'm struggling to understand why I'm receiving this "#REF!" error. The formula in AT is =if(sum(AS3:INDIRECT(CONCATENATE("AS",(JJ3+3))))>0,1+AT4,0) . The JJ column currently shows 166, so AT should find the sum of AS3:AS169. For whatever reason I seem to get this error about half of the time, but I get it less when JJ is a smaller number. For example if I change the "JJ3+3" part of the formula to "JJ3-100" I don't receive the error but then AT is not showing me the correct number. I'm hoping you can help me troubleshoot this.