I am trying to sum 12 columns based on looking up a reference that is in one column.
Basically I have 2 files where on both files Column A has a G/L account number. On the data file I have credits for each month going from column C to Column O. On the other I have one column where I want to bring in the sum of all the months based on looking up the G/L number in column A.
Any help you can give would be great if you have any questions please ask. Sorry I feel like this should be easy but I just can't think of what to do and since I don't know the correct function I can't search for it.
Thank you in advance!!!
Bookmarks