+ Reply to Thread
Results 1 to 4 of 4

4 x 4 matrix array sum problem

  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Hong Kong
    MS-Off Ver
    Office 365 PC Version
    Posts
    204

    4 x 4 matrix array sum problem

    dear all thank you for reading my thread.

    I have a 4 x 4 matrix with the 5th column being the total for each row as follows:

    1 2 3 4 10
    5 6 7 8 26
    9 10 11 12 42
    13 14 15 16 58

    I have an array formula to check to see if the total for each row column 1 to 4 equals the total 5th cloumn as follows:

    {SUM(IF(E14:E17+F14:F17+G14:G17+H14:H17=I14:I17,1,0))} with the result being 4.

    How do I use an array formula to test the matrix so for example sum(E14:h17) on a row level = I14:I17

    Thanks and regards John

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: 4 x 4 matrix array sum problem

    An adaptation of your array formula itself perhaps..

    =E14:E17+F14:F17+G14:G17+H14:H17=I14:I17
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: 4 x 4 matrix array sum problem

    An adaptation of your array formula itself perhaps..

    =E14:E17+F14:F17+G14:G17+H14:H17=I14:I17

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,627

    Re: 4 x 4 matrix array sum problem

    Or you can use conditional formatting on I column to paint values if not true:

    =I4<>SUM(E4:H4)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1