CODEWITHSUNDEEP
excel
user1527227
user1527227

Reputation: 2248

How to perform column to row operations in excel

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

Upvotes: 0

Views: 725

Answers (1)

Scott Craner
Scott Craner

Reputation: 152605

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

=SUM(VLOOKUP("CF" & G1,$A$2:$C$7,{2,3},FALSE))

Being an array formula it needs to be confirmed with Ctrl-Shift-Enter when exiting edit mode instead of Enter. If done correctly then Excel will put {} around the formula.

enter image description here

Upvotes: 1

Related Questions