Forum Discussion
Excel 2016 formula Adding spreadsheetl data with negative number which needs to be made positive
Spread sheet In formula IMSUB ( F4,E5,G5 ) , sometimes Col E data may be negative, but the sum in Col J ( total kw usage for day ) , E5 has to added.
Col E data comes from sum of daily meter readings in Col B, where solar may have made meter go backwards.
| Date | PSEG-Meter | ReadTime | Temp/Weath | PSEG Day | PSEG-Eve | Panels KWH | Vivint Totals | SunRun | Total KW |
| 44 - 11.44kw | Enphase sys | per day | per day | ||||||
| 1/1/23 | 37996 | 7a | 50,pc | 37 | |||||
| 37989 | 5a | 50,pc | -7 | 33.98 | 33.98 | 63.98 | |||
| 1/2/23 | 38035 | 9a | 40,clouds | 46 | |||||
| 38064 | 8p | 45,pc | 29 | 7.32 | 41.3 | 82.32 | |||
| 1/3/23 | 38102 | 8a | 47,rain | 38 | |||||
| 38124 | 5p | 52,drizzle | 22 | 2.58 | 43.88 | 62.58 | |||
| 1/4/23 | 38163 | 7a | 50,drizzle | 39 |
- EDIT - E-5 in above , when negative, should be ignored. How to?
