| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2000: Adding column D based on value in column A
Hi,
In a worksheet I have dates in column A (format 03/18/2008,/03/17/2008,03/17/2008) and in column D i have numbers (format 0.4,1.0.3). I am looking for a formula to total all of the numbers where the date happens to be a Monday - example: Column A Column D 3/17/2008 0.5 3/17/2008 1 3/18/2008 2 I would like a formula that returns "1.5" because 3/17/2008 is a Monday. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a Custom Column based on an existing Column (EXPERT) | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Adding one column based on results from another column | Excel Discussion (Misc queries) | |||
| Adding a column based on greater than a date | Excel Worksheet Functions | |||
| Adding Values Based on a Separate Column | Excel Discussion (Misc queries) | |||
Threaded Mode
