Help with summing across columns please

jdsg0 · #1 12-08-2016, 04:13 AM

Hi, the data for week 2 starts from Monday Jan 8th found in the data sheet cells AJ13-AN13.The amount of money that should show for Jan 8th (Cell B4 on the summary sheet) is £130 but the formula does not copy down. I have filled in all of week 2 data on the data sheet so hopefully this is usable but if you need more, please let me know

xor · #2 12-08-2016, 09:43 AM

In the attached I have created a named range, d. See Name Manager. And I have inserted a new sheet, Data2 to make the calculations in Summary Sheet easier.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Summing Durations between 2 locations?	Avsfan3319	Excel	1	03-06-2016 05:40 PM
Challenge summing time (mm:ss) values?	Mr Davo	Excel	3	12-17-2014 10:41 AM
New Cost columns are not summing up.	elvanaguven	Project	3	11-08-2014 02:28 PM
Why does not summing up from different sheet work?	Kh1978	Excel	1	05-14-2014 02:22 AM
SUMMING TWO COLUMNS	LOGISTICS1	Excel	1	04-18-2006 06:00 AM