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..

Please see my file below.. Thanks..

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..

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.

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..

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

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?

Powered by vBulletin® Version 4.2.5 Copyright © 2020 vBulletin Solutions Inc. All rights reserved.