Add a value to a current cells value

wizard94

New Member
Joined
Feb 20, 2019
Messages
4
Hi there,

I have a worksheet that pulls through hourly sales for the previous trading week. It stores these values for Monday C4:C25, Tuesday F4:F25 and so on through to Sunday. For clarity, lets call that Table 1.

I want to be able to compute an average of sales taken within a certain trading hour for a number of weeks so it builds up historical trading data by hour. To do that, I need the value of the hourly sales from Table 1 to add to the current value in Table 2; Monday X4:X25, Tuesday Z4:Z25 etc

So i.e starting from scratch:

Week 1
It pulls through an hourly sales of £10.00 between 6am - 7am into C4. It then adds this value to the current value in X4 giving X4 a value of £10.00 (as previously would be 0)

Week 2
Hourly sales for the next trading week between 6am - 7am are pulled through into C4 as £15.00. It then adds this value to the current value of X4 giving a value of £25.00

.. then repeating for each subsequent week.

Is this something anyone can help with please?

Thank you!
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,110
Office Version
  1. 365
Platform
  1. Windows
Cant say as id ever do it like you describe. Id be creating a database of values that gets new data appended to it each week then sum them up using a pivot table or a SUMIF formula.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,027
Messages
5,526,329
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top