Adding a range of numbers between to data points

Hi,

Need help in building a formula that will sum a range of number based on a start weight and end weight within a matrix. Result will go into Cell B10 in the spreadsheet.

Need to add a range of numbers in the D column between the start weight shown in B7 and the end weight shown in B8. Weight column (Column A) is the array of weights to reference.

Note that in column A, there are gaps between numbers. Formula must find number closest in the range. Example: Formula would find A33 (400) to be the start weight for this is closest number to 401. It would find A354 (1299) for this is the number closest to 1300 shown in B8.

Thank in advance for the help.

-Manny

It seems to me like a basic SUMIFS() function: https://support.office.com/en-us/art...6-611cebce642b Try something like =SUMIFS(D15:D408,A15:A408,">=400",A15:A408,"<=1300")

Note that the criteria is just a text string ">=400". You can use the CONCATENATE() function or concatenate operator & to combine the relational operator with a cell value into the resulting string ">="&B7, for example.