c1.jpg
c2.jpg

Dear All,

I have a Loan Amortization program which is dynamic in nature. It takes inputs from users and expands according to the inputs.
I have dragged the formula to about 400 rows below and according to the users inputs, the rows are populated and the rest are programmed to show "".

This is where the problem is. In one column, I am using a SUMPRODUCT formula which is dependent on one of the columns where the formula is dragged to 400 rows below.

Because some rows will be populated with the numeric values and the rest will show "" (blank) hence SUMPRODUCT gives 'VALUE' error.

I was just hoping is there any way where to have a dynamic array for SUMPRODUCT which goes until the last numeric value in that column it is depending on?
Or can anyone tell me any alternative?

Any SUPPORT will be highly appreciated.

Best Regards