You could try using JDBC Options Binder in Load Binder, to read the DB table containing both spreadsheets values and use SQL to sum them before displaying in the form.

OK Thanks for the details, let me try to implement this.

I need one more query related spreadsheet. Please guide me.

I have a one form on the form dropdown in this dropdown LOV (department details) based on department 5 to 6 details are showing. I want to those 5 to 6 details showing in the spreadsheet first column.

I am trying to use the JDBC binder in spreadsheet with select query where clause but unable to do it,  because in the where clause using  id='#form.table.fieldname#' but unable to find the hash variable values.

Please suggest me.

Remember that to use #form.table.fieldname#, the record must already exist in DB. You could try using #requestParam.id# if you have the record id in the url of the opened form.

Thanks as per your advise, I was trying to use but it is not working.

Let me explain again 

Division List,  Once division select need to sub-division display into the spreadsheet column

Spreadsheet: Under Scope of work column now showing 2 that is default value set but I want to select division based on that display the data .

Query: Query I am trying to use on Spreadsheet JDBC Binder 

SELECT c_sub_division as scopeofwork FROM app_fd_subdivision_profile where c_division='#form.ipadetails.division#';

ipadetails: Current form table

As mentioned earlier, to use the #form....# hash, this value needs to be in the database, not currently edited form where you change the field value.

Do try using instead the AJAX Subform where the spreadsheet sits in the subform and you link the subform to the selectbox field. And in your subform load binder, use this hash '#requestParam.primaryKey#' variable in your SQL WHERE clause. Using the Ajax Subform, you can then populate the subform containing the spreadsheet dynamically and in real time. There is a demo app in this KB page you can download to learn how.

Thanks Matthew , will check and let you know