Adding Colums from yesterday

D

David Hopper

I have created a daily report to track revenue and marketing
information. This report includes columns titlted

Today Month to Date Year to Date


Is there a formula that will automatically add the "Today" column to
yesterday "Month to Date" and "Year to Date" columns bringing the MTD
and YTD columns current.

Thanks

David Hopper
 
R

Roger Govier

Hi David

I presume you have missed out a column and what you really have is
Date Value MTD YTD
where column B holds the value that you want summed.

If so, cell C2 =B2, cell D2 =B2
In cell C3
=IF(A3="","",IF(MONTH(A3)<>MONTH(A2),B3,C2+B3))
in cell D3
=IF(A3="","",IF(YEAR(A3)<>YEAR(A2),B3,D2+B3))
Copy both formulae down as far as required
 

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

I'm stuck on a circular reference 4
if function (if more that 7 nesting) 2
Adding Columns if Criteria Met 1
Month to date (MTD) calculation 9
SubQueries in Column 1
a Month to Date and Year TD page in one sheet changing each day? 1
Choice of Formula 4
Linking Data from 1 worksheet to another by using dates? 1

Top