I am trying to have the SUM of multiple rows only shown in one row, i.e) the sum of range A2:A10 to show in only A10. There are part #'s that I also need to consider when creating the formula. For example, I have Part # 231, Part # 233 & Part #433. I need the sum of these part numbers kept separate, but I'd like to be able to use the same formula as there is thousands of rows. Any Ideas, I have tried many variations but none seem to be working - I am looking for help!!