Raghava@rock
Member
Hi Team,
I was trying to use sumifs Formula to sum the values in the table which match the row & column. below is teh example. I need put a formula to summ all the values which are under header ZZ and matching A1 in X header.Please help urgent
X XY YZ ZZ XY YZ ZZ XY YZ ZZ
A1 53 66 65 29 3 37 27 59 30
A2 70 40 87 3 7 57 22 37 34
A3 21 1 82 47 33 2 84 71 85
A4 87 26 31 74 54 44 94 83 97
A5 49 41 38 22 53 32 34 58 26
A6 52 27 34 18 36 62 77 13 7
A7 67 45 85 27 97 61 61 2 14
A8 50 57 3 86 54 86 76 4 94
A9 20 26 12 19 58 9 46 51 15
A10 40 54 19 87 41 32 44 48 7
A11 59 82 25 72 80 48 2 63 18
A12 88 39 57 21 22 91 14 96 15
A13 48 99 87 37 15 40 34 98 29
A14 67 3 36 65 71 5 89 51 96
A55 69 31 28 6 30 70 63 88 95
Required result ZZ Result
A1 =D2+G2+J2 132
I was trying to use sumifs Formula to sum the values in the table which match the row & column. below is teh example. I need put a formula to summ all the values which are under header ZZ and matching A1 in X header.Please help urgent
X XY YZ ZZ XY YZ ZZ XY YZ ZZ
A1 53 66 65 29 3 37 27 59 30
A2 70 40 87 3 7 57 22 37 34
A3 21 1 82 47 33 2 84 71 85
A4 87 26 31 74 54 44 94 83 97
A5 49 41 38 22 53 32 34 58 26
A6 52 27 34 18 36 62 77 13 7
A7 67 45 85 27 97 61 61 2 14
A8 50 57 3 86 54 86 76 4 94
A9 20 26 12 19 58 9 46 51 15
A10 40 54 19 87 41 32 44 48 7
A11 59 82 25 72 80 48 2 63 18
A12 88 39 57 21 22 91 14 96 15
A13 48 99 87 37 15 40 34 98 29
A14 67 3 36 65 71 5 89 51 96
A55 69 31 28 6 30 70 63 88 95
Required result ZZ Result
A1 =D2+G2+J2 132
