Users will select from a data validation list (6 choices) in blocks of rows (in column C). Eg; rows 8 -18, 23-43, 48-60, 66-83.
I need to assign a different value to each of the choices (say 1 to 6) and calculate the total value for each block of rows & display that total in column D, next row down, eg; total for rows 8-18 will display in D19.
I have similar requirements are on other worksheets in same file, just the blocks of rows differ.
Your help will be greatly appreciated.