Hi guys, wondering if you would be able to help me with what is probably a very easy problem to solve, but im a bit of a VBA novice and im not sure how to go about doing this in excel. I have a 3x3 grid of numbers, lets assume A1:C3. I would like to take each individual cell in that array and add all the inverses of each cell together...

a1-1+b1-1+c1-1
a1-1+b1-1+c2-1
a1-1+b1-1+c3-1
a1-1+b2-1+c1-1
a1-1+b2-1+c2-1

etc etc.

And I would like the results to be put on an adjacent column, or perhaps a new sheet.

Could anyone give me an idea how I might go about doing this please?

Many Thanks

Miguel