Automating Subtotal
 

I would like to total two columns on a daily basis. The subtotal function
performs what I need but with two draw backs. The first draw back is
additional steps for end user and second is processing again if additional
information is added after the subtotal has been performed.

My spreadsheet has two columns: Colmun A is dates and Column B is values. I
would like a simple way to enter dates and have it total the values of each
date in Column C. The daily totals must be retained and not over written due
to the use of this report. Please keep in mind that the number of enteries
per day varies throughout the month.

Automating Subtotal
 

try putting the dates for the month in column d and then use
=SUMPRODUCT(--($A$2:$A$25=D2),$B$2:$B$25) in column E and fill down for all
the dates of the month. You will need to update the range for columns A & B
in the formula as required. You will then have a total for each date as a
summary

--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Val" wrote:

I would like to total two columns on a daily basis. The subtotal function
performs what I need but with two draw backs. The first draw back is
additional steps for end user and second is processing again if additional
information is added after the subtotal has been performed.

My spreadsheet has two columns: Colmun A is dates and Column B is values. I
would like a simple way to enter dates and have it total the values of each
date in Column C. The daily totals must be retained and not over written due
to the use of this report. Please keep in mind that the number of enteries
per day varies throughout the month.