# Thread: I need a formula..

1. ## I need a formula..

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

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

3. Thank you ashleyuk1984, It works great.

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

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

6. I have 8 sections so I will write SUMIF formula 8 times and use + , is that right? Isn't there another solution?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•