Add a value to a current cells value

[wizard94]

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!

 

[steve the fish]

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.