I have excerpted 2 rows of data: dates with their corresponding values. I want to sum the 5 values immediately following any one of the dates I select (the variable). In other words I want to sum the values for Mar 11 thru 15 when Mar 8 is the variable specified. The variable is generated elsewhere in the spreadsheet so it would be specified by a cell reference in the formula. I have experimented with “Offset” and “Sum Offset” but I am unable to plug the variable’s cell reference into a formula that does not result in an error code. What should a viable formula look like? Thanks.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.