Login Page - Create Account

Support Board


Date/Time: Wed, 24 Apr 2024 14:04:42 +0000



Post From: Spreadsheet

[2019-09-26 14:49:21]
AndreyPoroshin - Posts: 102
=SUM(INDEX(F$3:F$1002,MATCH($H$3,Z$3:Z$1002,-1),1)
:INDEX(F$3:F$1002,MATCH($H$4,Z$3:Z$1002,-1),1))

The formula for calculating the volume from your site. It is not clear what she is showing. First in cell H6 #REF? Secondly, if I disassemble it into components in columns V X, the result AA is not corresponding to the sum of the volume in the interval between 08:25:00 - 14:40:00. Maybe I did not understand the functionality correctly?
Date Time Of Last Edit: 2019-09-26 14:51:20
Private File