How To: Find the diagonal sum in Excel

Find the diagonal sum in Excel

How to Find the diagonal sum in Excel

In this how to video, you will learn how to create a diagonal sum in Microsoft Excel 2007. First, open the program and make a large selection. Type in =int(rand()*500) and then press control enter. This will create random numbers for the cells in the selection. From here, click conditional formatting and select new rule. From here, type in =column(A1)-row(A1)=$H$1. For the format, choose a contrasting look, such as a purple background and bold numbers. Click okay. If you type -1 or -2 in this column, it will move the purple diagonal background up or down the selection of numbers. Next, in a blank cell type in =sum((column(A1:E5)-row(A1:E5)=H1)*AI:E5) and then press control shift and enter. You will get the sum of these diagonal numbers.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest