I have Ref no. in Col A on Sheet "Data" and values in Col B
I need to sum the values based on a range of Ref no's on sheet 'Summary"
for eg ref Z-763000 to Z-763500. the current Range may only have values for Eg Z-763000,Z-763020,Z-763200. I would like a formula that will change the values if new ref No. in the range is added at a later stage
I have attached some sample data
Bookmarks