Support Board
Date/Time: Tue, 26 Nov 2024 17:45:46 +0000
Post From: sumproduct issue and depend bartime
| [2023-11-17 10:22:16] |
| User278398 - Posts: 291 |
|
hello, im trying to sum the last 60 last bars and which start from bartime=1 for exa: if the value for all bars are "1" so: at 9:30:00 the value will be: 1 at 9:30:01 the value will be: 2 at 9:30:59 the value will be: 60 at 9:31:00 the value will be: 1 at 9:31:01 the value will be: 2 /// maybe for an ideas: im using sumproduct formula and second(bartime)>0,second(bartime)<60 but i didnt get the right values :( ... what is the solution by formula? thank you |