Support Board
Date/Time: Thu, 13 Feb 2025 13:36:19 +0000
Post From: Help with a Spreadsheet Sum column upon a condition then start from 0
| [2020-12-05 21:19:20] |
| User215984 - Posts: 24 |
|
Hi, I would appreciate any help on how to sum a column if: A. Close <= Previous Close Sum Col{x} starting at this row B. Until Close >= Previous Close Start from 0 and sum again (A) happens again Close Val Sum/Total 11.25 3 3 11.24 5 8 11.23 2 10 - 11.21 7 7 11.22 2 9 11.22 3 12 11.28 1 13 - 11.20 4 4 11.19 2 6 Thanks! |