So I have a formula like this. Basically it is in the worksheet or “tab” control and it looks up a cable tag on the M102 then the cable length is on the E4-105. Then it goes back to the M4-105 and looks for duplicate tags of the same and adds them together to get a total length for me. This is good but I also want a way to have that formula in another light to remove duplicate as well if possible. I tried the unique formula at the end but I believe it doesn’t work in the same column I put the below formula in and also not 100% if it can see the output # as a duplicate because its a formula?

=IF(M87<>””,SUMIF(CONTROL!$M$4:$M$105,M87,CONTROL!$E$4:$E$105),””)

I tried this below but didn’t work.

=IF(M4<>””, SUMIF(CONTROL!$M$4:$M$105, M4, CONTROL!$E$4:$E$105), UNIQUE($X$4:$X$105))

​So I have a formula like this. Basically it is in the worksheet or “tab” control and it looks up a cable tag on the M102 then the cable length is on the E4-105. Then it goes back to the M4-105 and looks for duplicate tags of the same and adds them together to get a total length for me. This is good but I also want a way to have that formula in another light to remove duplicate as well if possible. I tried the unique formula at the end but I believe it doesn’t work in the same column I put the below formula in and also not 100% if it can see the output # as a duplicate because its a formula? =IF(M87<>””,SUMIF(CONTROL!$M$4:$M$105,M87,CONTROL!$E$4:$E$105),””)I tried this below but didn’t work.=IF(M4<>””, SUMIF(CONTROL!$M$4:$M$105, M4, CONTROL!$E$4:$E$105), UNIQUE($X$4:$X$105))  Read More

​