Using if or sum if to change range of sums

S

Stuck with Excel

Hi,

I have a spread sheet which compares to ranges of data which changes during
the course of the week.

One range of data compares the current week as it builds against the
previous week and I would like it to compare the same days as the week builds.

Now I can do it manually by expanding the ranges each day, but I am aiming
to automate this so it updates automatically. I believe something can be
done using IF or SUMIF in some way but it is just not working for me at the
moment.

Help please?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum all sheets if Column L 3
Page numbering with Merged Document and IF statements 1
Dealing with a Pivot Table (when I don't want to) 0
Creating Network Diagram using a Chart SW integration 0
use xlup and offset in a range of cells 1
IF then SUM 5
A couple questions BEFORE using Office 365 0
average if question 2

Top