Enter your data or use an existing data. Type into the cell where you want to place the result =SERIESSUM(A2,0,2,D2:D4). Press Enter to see the result. The result is 0.504711076. There are two other ...

SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.