Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |