Support Board

Date/Time: Mon, 16 Sep 2024 19:31:14 +0000

Post From: SUM spreadsheet column by date

[2017-05-03 21:59:23] Link To Thread - Link To Post [Go To First Post]
User98657 - Posts: 322
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.