# Difference of Column with Multiples of the Same Entry

#### raynebowx

##### New Member
I want it to take the difference of one 1 column minus a certain box and add together only 1 unique value since theres multiples of the same entry.

SUM(E8:E50)-L4

Which worked until column E had several entries with the same value. Then it added column E together so the number was massive.

TIA!

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
You could uses a helper column

Formula in L6
=SUM(F8:F50)-L4

Formul in F8 copied down
=(COUNTIF(\$E\$8:E8,E8)=1)*E8

Excel 2016 (Windows) 32 bit
E
F
G
H
I
J
K
L
M
3
4
10​
5
6
45​
=SUM(F8:F50)-L4
7
HELPER
8
1​
1​
=(COUNTIF(\$E\$8:E8,E8)=1)*E8
9
2​
2​
10
3​
3​
11
4​
4​
12
5​
5​
13
6​
6​
14
7​
7​
15
8​
8​
16
9​
9​
17
10​
10​
18
1​
0​
19
2​
0​
20
3​
0​
21
4​
0​
22
5​
0​
23
6​
0​
24
7​
0​
25
8​
0​
26
9​
0​
27
10​
0​
28
1​
0​
29
2​
0​
30
3​
0​
31
4​
0​
32
5​
0​
33
6​
0​
34
7​
0​
35
8​
0​
36
9​
0​
37
10​
0​
38
1​
0​
39
2​
0​
40
3​
0​
41
4​
0​
42
5​
0​
43
6​
0​
44
7​
0​
45
8​
0​
46
9​
0​
47
10​
0​
48
1​
0​
49
2​
0​
50
3​
0​
 Sheet: Sheet1

Replies
8
Views
608
Replies
0
Views
575
Replies
0
Views
368
Replies
3
Views
98
Replies
0
Views
105

1,203,174
Messages
6,053,912
Members
444,694
Latest member
JacquiDaly

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back