Support Board
Date/Time: Tue, 14 Jan 2025 11:48:35 +0000
Post From: SUM spreadsheet column by date
| [2017-05-03 21:59:23] |
| User98657 - Posts: 329 |
|
i'd like to know if there's a way to sum, Average, and find the Max and Min for a column in a spreadsheet but only for the values for today. My spreadsheet includes all the dates loaded on the chart of course, but i want to base a formula on certain parameter relative to today's trading only. I've looked through the documentation and i'm not seeing any way to construct a formula to provide, for instance, a sum of values from today's date. in Excel this would be akin to SUMIF, AVERAGEIF, MAXIFS, AND MINIFS. |