Forum Discussion
Creating New Table with SUMPRODUCT from Existing Tables
I have 2 separate tables (PmtTable, RateTable) that I'd like to use to create a new table (NewTable) that has a SUMPRODUCT calculation that is derived using the two original tables. Using Excel it w...
Hi Anonymous
There seems to be something wrong with the code you provided, and I don't quite understand what you need.
If you can, please provide some dummy data and desired results. It is best presented in table form.
Regards,
Nono Chen