Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to add a column of entries, but only if a date is entered in an
another column. In other words: add fees in column c if they have a start date listed in column d- if column d is empty I do ont want the fees entered in column c to be added in. ie: a b c d e name status fees start date Billy active $25 Nov 21/08 Sue pending $50 Mary active $30 Jan 16/09 Frank active $45 Oct 31/08 George pending $40 So for Sue and George I do not want the fees added to the total fees because they have no start date, yet. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding double quotes around entries in a column | Excel Discussion (Misc queries) | |||
Adding suffix to column entries | Excel Worksheet Functions | |||
Adding up entries in one column with conditions in two columns | Excel Discussion (Misc queries) | |||
Sum Column Entries that fall within Date Range Listed In Rows | Excel Worksheet Functions | |||
Adding a column based on greater than a date | Excel Worksheet Functions |