SUM cells with equal values in an adjacent column.

**zbor** · 12-13-2013, 09:05 AM

Both of them?

try replace them with:

Formula:

=IF(COUNTIF(C$2:C2;C2)=1;SUMIF($C$2:$C$1000;C2;$E$2:$E$1000);"")

Formula:

=IF(SUMPRODUCT(--(C$2:C2=C2);--(D$2:D2=D2))=1;SUMPRODUCT($E$2:$E$1000;--($C$2:$C$1000=C2);--($D$2:$D$1000=D2));"")

Extend range (1000) if needed

**angelopc** · 12-13-2013, 09:18 AM

This seems to work just the way I need it to. I'm freakin' overjoyed!

Originally Posted by zbor

Both of them?

try replace them with:

Formula:

=IF(COUNTIF(C$2:C2;C2)=1;SUMIF($C$2:$C$1000;C2;$E$2:$E$1000);"")

Formula:

=IF(SUMPRODUCT(--(C$2:C2=C2);--(D$2:D2=D2))=1;SUMPRODUCT($E$2:$E$1000;--($C$2:$C$1000=C2);--($D$2:$D$1000=D2));"")

Extend range (1000) if needed

Re: SUM cells with equal values in an adjacent column.