Support Board
Date/Time: Tue, 04 Mar 2025 10:18:17 +0000
Post From: Counting signal from studies in spreadsheet
| [2019-02-26 18:27:56] |
| jenda3 - Posts: 21 |
|
Hi, i use spredsheet and i need count how many times studie give me a signal. I have in spredsheet 1000 rows For exemple: to static cell J98 i put this If(AND(AA3>0,AB3>0),1,0). This formula give me 1 when condition is true. And in static cell J99 i want count how meny times is "1" in cell J98. So in the beginning it's in the cell J99 "0", when cell J98 gives me "1" tehn in cell J99 is "1" and for exemple after 2000 bars cell J98 gives me again "1" then a need in cell J99 "2" etc... So the point is - i don't want count bars but situations Is it possible in spreadsheet? |