I need a formula for H10 to AD10 (Total Weights of each Zones) and for H11 to AD11 (Total Index for each Zones).
Please see my file below.. Thanks..
I need a formula for H10 to AD10 (Total Weights of each Zones) and for H11 to AD11 (Total Index for each Zones).
Please see my file below.. Thanks..
Last edited by akinkaraman; 02-28-2015 at 02:12 PM.
Hi,
In H10.
Then drag it across.=SUMIF($H$7:$AE$7,H9,$H$5:$AE$5)
In H11.
Then drag it across.=SUMIF($H$7:$AE$7,H9,$H$6:$AE$6)
Hope this is what your looking for.
Thank you ashleyuk1984, It works great.
I want to ask something that I want to update my sheet. In the following file, Sheet 2 has the working formula whenf we have 1 section, what if we have more than 1 section?
What formula should I use for I17 to AE17 (Total Weights of all sections due to each Zones) and I18 to AE18 (Total Index of all sections due to each Zones) in Sheet 1?
Thanks..
Last edited by akinkaraman; 03-01-2015 at 09:50 AM.
Well, I tried to produce a SUMIFS formula, but I couldn't get it right... So instead, I just opted for two SUMIF formulas.
In I17 put
And then drag it across=SUMIF($I$7:$AF$7,I19,$I$5:$AF$5)+SUMIF($I$14:$AF$14,I19,$I$12:$AF$12)
And in I18 put
And then drag it across=SUMIF($I$7:$AF$7,I19,$I$6:$AF$6)+SUMIF($I$14:$AF$14,I19,$I$13:$AF$13)
I have 8 sections so I will write SUMIF formula 8 times and use + , is that right? Isn't there another solution?