Login Page - Create Account

Support Board


Date/Time: Mon, 03 Feb 2025 16:52:59 +0000



Post From: Spreadsheet

[2019-09-26 16:30:11]
Sawtooth - Posts: 4164
Use this formula instead:
=SUM(INDEX(F$3:F$1002,MATCH($H$4,Z$3:Z$1002,-1),1):INDEX(F$3:F$1002,MATCH($H$3,Z$3:Z$1002,-1),1))

Note: H3 must be earlier than H4.

The original formula does not work in the New Spreadsheets.
The webpage has been updated.