# Sum all values in columns B, C and D if Values in column A don't change and show total in last row of column E

#### lfellows

##### New Member
Hi,

Say for example I have today's date in A2:A4, and various number values in B2:D4, is there anyway I can show the total sum of the values in B2:D4 in cell E4? (this is in a table)

There may not always be three rows, there could be four or five rows for tomorrows date and so on for the dates after.

I hope this makes sense.

Liam

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### kweaver

##### Well-known Member
Without seeing your layout, it's difficult to understand fully what you want. Will this get you started?

Book3 (version 1).xlsb
ABCDE
1DatesData
23/1/20216108
33/1/2021124
43/1/202158751
53/5/2021310215
63/15/2021335
73/15/202157831
Sheet2
Cell Formulas
RangeFormula
E7,E4:E5E4=SUMPRODUCT((A4=\$A\$2:\$A\$7)*\$B\$2:\$D\$7)

#### lfellows

##### New Member
Yeah you hit the nail on the head, this is what I had in mind

Book1
ABCDE
1DATEVALUE 1VALUE 2VALUE 3TOTAL
211/03/2021104070
311/03/2021205080
411/03/2021306090450
512/03/2021105090
612/03/20212060100
712/03/20213070110
812/03/20214080120780
Sheet6
Cell Formulas
RangeFormula
E4E4=SUM(B2:D4)
E8E8=SUM(B5:D8)

Replies
4
Views
53
Replies
5
Views
228
Replies
3
Views
196
Replies
6
Views
258
Replies
9
Views
71

1,130,309
Messages
5,641,448
Members
417,209
Latest member
Agbarker

### 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