Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 20 Apr 2024 12:04:37 +0000
Post From: Spreadsheet
| [2019-09-26 16:30:11] |
| Sawtooth - Posts: 3976 |
|
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. |