Adding Colums from yesterday

  • Thread starter Thread starter David Hopper
  • Start date Start date
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
 
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
 
Back
Top