In mrexcel.com/forum/excel-questions, you wrote:

``Lemme explain better what i did which i believe is giving me wrong answers.I used fill handle to do the increasing factor for each column.Then use the all data to perform SUMPRODUCT for the estimated hours. But that approached fails!``

Perhaps you merely need some guidance in using mixed relative/absolute references of the form A$1 and $A1.

It would behoove you to attach an Excel file that demonstrates your values and formulas in your table.

Sadly, that's not as easy as it should be. The "Attachments" botton in the toolbar after you click "Go Advanced" does not work. Instead, scroll down and click "Manage Attachments".