Assistance with SUM with conditions

Please try this function

Note: Require Ctrl+Shift+Enter
=SUM(IF(FREQUENCY(IF($C$7:$C$14<>"",MATCH($C$7:$C$14,$C$7:$C$14,0)),ROW($C$7:$C$14)-ROW($C$7)+1)>0,$J$7:$J$14))

Put this formula in K7:

=IF(COUNTIF(C$7:C7,C7)=1,SUMIF(C:C,C7,J:J),"")

It should be copied down your table automatically when you press <enter>. It gives you the totals for each project owner only on the first occurrence of their name, so a SUM of that column will give you 210.

Hope this helps.

Pete

EDIT: Maybe you should use this in K7:

=IF(COUNTIF(C$7:C7,C7)=1,J7,"")

then the sum of this is 170.

Hope this helps.

Pete

Hello D,

do you mind using a helper column? If we can use K as the helper column, then in K7:

Formula:

Please Login or Register  to view this content.

Copy this down to K14.

Then the total members

Formula:

Please Login or Register  to view this content.

Cheers

@Pete - very elegantly done. But it may need this tweak:

Formula:

Please Login or Register  to view this content.

Without this division by COUNTIF(), it adds up all instances of Adam Albert's team.

What do you think?

Cheers

Saw it now. Much simpler.

Cheers