PDA

View Full Version : I need a formula..

akinkaraman
02-28-2015, 12:38 PM
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..

ashleyuk1984
02-28-2015, 03:08 PM
Hi,
In H10.

=SUMIF(\$H\$7:\$AE\$7,H9,\$H\$5:\$AE\$5)

Then drag it across.

In H11.

=SUMIF(\$H\$7:\$AE\$7,H9,\$H\$6:\$AE\$6)

Then drag it across.

Hope this is what your looking for.

akinkaraman
02-28-2015, 03:34 PM
Thank you ashleyuk1984, It works great. :)

akinkaraman
03-01-2015, 07:37 AM
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..

ashleyuk1984
03-01-2015, 10:16 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

=SUMIF(\$I\$7:\$AF\$7,I19,\$I\$5:\$AF\$5)+SUMIF(\$I\$14:\$AF\$14,I19,\$I\$12:\$AF\$12)

And then drag it across

And in I18 put

=SUMIF(\$I\$7:\$AF\$7,I19,\$I\$6:\$AF\$6)+SUMIF(\$I\$14:\$AF\$14,I19,\$I\$13:\$AF\$13)

And then drag it across

akinkaraman
03-01-2015, 11:03 AM
I have 8 sections so I will write SUMIF formula 8 times and use + , is that right? Isn't there another solution?