Steven Morgan Posted March 19, 2020 Share Posted March 19, 2020 For some reason simple math isn't working in my worksheets when referencing database values. If I try to manually add cells together it works fine. Example attached, issue is on the "Sub-Total" column (F3). WorksheetMath.vwx Quote Link to comment
Pat Stanford Posted March 19, 2020 Share Posted March 19, 2020 Rather than trying to pull the summed value from Column A, use the Count() function directly and change the F3 formula to =(Count()*E3) The worksheet is trying to operate on the summarized subrows rather than on the value that is displayed in the subrow. Broken, but Working As Designed. 😞 Quote Link to comment
Steven Morgan Posted March 19, 2020 Author Share Posted March 19, 2020 Ah, that sorta actually makes sense. Thanks as always Pat! Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.