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
Bookmarks