Hello,
I am using Excel 2016.
I want to sum all DIAGONAL entries
My current formula does not work for some reason.Please Login or Register to view this content.
I would think that this sums the entries from A1 to D4, if the column number is equal to the row number.Please Login or Register to view this content.
Which should equal 4.
I would greatly appreciate if anyone could let me know what is wrong with my formula
and what is/are the correct ways) of doing this.
Thank you!
Bookmarks