SUM COLUMN INDEX

[staffie007]

Hi All,

I wonder if anyone can help me...?

I have two workbooks
WB1. With RAW data
WB2. With a list of variables to be pulled through

I have Column headings in WB1 eg GFS_Deposits & GFS_Payments
I would like to sum all the rows in WB2 using the reference GFS_Deposits
Using the Match formula, I can get the column index, but dont know how to then sum that column.

Can anyone help?

Thanks in advance

 

[venkat1926]

in the absence of actual configuration of your data I can only suggest you an use sumproduct formula.