VBA Sum Dynamic Range

Thanks. However, the code did not work as I expected. I have attached a sample workbook. Column B is where I am trying to populate the values. In row 3 for example, I want it to look at cell E3, see that it has a value and then move to F3 and sum everything from F3 to X3. In row 10, I want it to sum everything from H10 to X10. all this will be based off a pivot table so the range will always be dynamic. Thanks in advance for the help.