How to SUM with multiple variable rows?

[WouterKabouter]

Hello,
I'm looking for help with a problem I have. This could've been answered already, but I couldn't find anything releated to my issue.

I've put in a part of a very long list with percentages. For Every 'number', which are variable, I need to SUM up the percentages. Because of the variable in the first column, I can't just drag the formula down.

Does anyone of you know which formula I could use for this?

Thank you!

Greetings

 

[Fluff]

Hi & welcome to MrExcel.
How about in I2 copied down

=IF(COUNTIFS(F$2:F2,F2)=1,SUMIFS(G:G,F:F,F2),"")

 

[WouterKabouter]

Hi & welcome to MrExcel.
How about in I2 copied down

=IF(COUNTIFS(F$2:F2,F2)=1,SUMIFS(G:G,F:F,F2),"")

Thanks for your reply!

It does seem to work, but I'm getting one error. I got the formula pasted into the main table, but I get an error about #NAME. My Excel is in dutch so that's why there is #NAAM on there.
I got another picture added in this message with the used formula on the right side. The Table is 1758 cells long.

Thank you!
Greetings.

 

[WouterKabouter]

I've fixed the #NAME? Issue. But when i fill in the formula in the first cell, it autofills everthing with zero's. The formula's in my language and english are next to each other.
Thanks!

 

[Fluff]

In Dutch it should be

=ALS(AANTALLEN.ALS(A$2:A2;A2)=1;SOMMEN.ALS(B:B;A:A;A2);"")

 

[WouterKabouter]

In Dutch it should be

=ALS(AANTALLEN.ALS(A$2:A2;A2)=1;SOMMEN.ALS(B:B;A:A;A2);"")

Yes, now it works. Thank you so much!
Greetings!

 

[Fluff]

You're welcome & thanks for the feedback.