Data is being entered on a daily basis into Excel. Each day the total for
the month or year needs to be summed.
Data is being entered on a daily basis into Excel. Each day the total for
the month or year needs to be summed.
Column labels in Row1.
Dates in Column A.
Data in Column B, from B2 to B366
Enter this formula in C2, and copy down to C366:
=IF(B2,SUM($B$2:B2),"")
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bdsirius" <[email protected]> wrote in message
news:[email protected]...
> Data is being entered on a daily basis into Excel. Each day the total for
> the month or year needs to be summed.
Hi
With your dates in column A and values in column B and assuming that row 1
contains headers then set up a series of dates in say column F2:F14 with
dates for the Year in question e.g. 1/1/05, 1/2/05, .... 1/12/05 (note these
are UK style dates, change to date format for your locality).
Put a heading in G1 Month Sales, in H1 Year to Date Sales
in G2
=SUMPRODUCT(--(MONTH($A$2:$A$1000)=MONTH($F2)),$B$2:$B$1000)
copy down through G3:G14
In H2
=SUMPRODUCT(--(YEAR($A$2:$A$1000)=YEAR($F2)),$B$2:$B$1000)
If you only wanted data for the year to date and the current month to date,
then for the month value use
=SUMPRODUCT(--(MONTH($A$2:$A$1000)=MONTH(TODAY())),$B$2:$B$1000)
Regards
Roger Govier
bdsirius wrote:
> Data is being entered on a daily basis into Excel. Each day the total for
> the month or year needs to be summed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks