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
Joined
Nov 22, 2019
Messages
35
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.

Thanks in advance
Liam
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,790
Office Version
  1. 365
  2. 2010
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
Joined
Nov 22, 2019
Messages
35
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,130,047
Messages
5,639,763
Members
417,109
Latest member
996

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top