Thanks for your reply. The row that is not calculating correctly is row 14 in the sheet Hours by Title Q1. In column C, for example, it should no longer use the data in cells B6-B12 (multiplied by the values in A6-A12), but should instead be using values in C6-C12, multiplied by the values in A6-A12.