How to perform column to row operations in excel

Tags: excel
Question!

enter image description here

Check out the selection in the top right, columns "Purchase/Sale" and "NOI".

I'd like to add these two columns and insert the sum for each period in their respective space. Is there I can link the sum of the columns and add the sum to the row?

In other words, I'd like the cells to link so I would have the following result:

enter image description here

Thank you



Answers

Use this array form of VLOOKUP wrapped in SUM():

=SUM(VLOOKUP("CF" 


This video can help you solving your question :)
By: admin