Trying to build Excel automated Cost Model

[svm24]

Hi All,

I am trying to creat a Automatic Cost model.

What i am looking for is:
To capture all various expenses in a single tab/place
To show overall financial summary separatly.

I knew only basics of excel and have limited knowledge of excel formulas like
if functions, vlook up, sumproduct..

can anyone help me with suggesting better ways of doing this, with ideas, formulas...

Thanks.

​