Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the right function & formula
I'm trying to find a function & formula that will add all the Volume Total
for specific day of the week in the Date column. For instance, I want add the sum of all the Monday volume totals and so forth...grouping the volume totals by day of the week. Column A Column B Date Volume Total Saturday, January 05, 2008 200 Sunday, January 06, 2008 209 Monday, January 07, 2008 231 Tuesday, January 08, 2008 240 Wednesday, January 09, 2008 201 Thursday, January 10, 2008 219 Friday, January 11, 2008 210 Saturday, January 12, 2008 182 Sunday, January 13, 2008 182 Monday, January 14, 2008 227 Tuesday, January 15, 2008 198 Wednesday, January 16, 2008 232 Thursday, January 17, 2008 221 Friday, January 18, 2008 191 -- Thank you. - KT |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having trouble finding the right function | New Users to Excel | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Help Needed with Finding a Function | New Users to Excel | |||
function for finding a value! | Excel Worksheet Functions | |||
Finding a function in Excel | Excel Worksheet Functions |