Support Board
Date/Time: Sun, 24 Nov 2024 01:13:30 +0000
Post From: Receiving "#REF!" Error in spreadsheet
| [2024-07-13 00:13:49] |
| 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.
|