Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding entries if date entered in another column
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding entries if date entered in another column
Here's two ways:
=SUMIF(B:B,"active",C:C) or: =SUMIF(D:D,"<",C:C) Hope this helps. Pete On Feb 17, 4:38*pm, Jen wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding entries if date entered in another column
try this formula in the total cell
=SUMPRODUCT((D2:D6<"")*C2:C6) this will not add the number if col D have a blank -- Hope this is helpful Appreciate that you provide your feedback by clicking the Yes button below if this post have helped you. Thank You cheers, francis "Jen" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding entries if date entered in another column
Thanks!
I had it close but I was missing the < =SUMIF(D:D,"<",C:C) I could not use the "active", because some of them are not in active status, even though they have a start date. Thanks for all your help. "Pete_UK" wrote: Here's two ways: =SUMIF(B:B,"active",C:C) or: =SUMIF(D:D,"<",C:C) Hope this helps. Pete On Feb 17, 4:38 pm, Jen wrote: 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding entries if date entered in another column
Hi Jen
No problem and thank you for your feedback. Am glad you got your solution. -- Hope this is helpful Appreciate that you provide your feedback by clicking the Yes button below if this post have helped you. Thank You cheers, francis "Jen" wrote: I did not try your suggestion, as the first post worked, but thanks so much for your help! "xlmate" wrote: try this formula in the total cell =SUMPRODUCT((D2:D6<"")*C2:C6) this will not add the number if col D have a blank -- Hope this is helpful Appreciate that you provide your feedback by clicking the Yes button below if this post have helped you. Thank You cheers, francis "Jen" wrote: 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding entries if date entered in another column
You're welcome, Jen - thanks for feeding back.
Pete On Feb 17, 5:23*pm, Jen wrote: Thanks! I had it close but I was missing the < =SUMIF(D:D,"<",C:C) I could not use the "active", because some of them are not in active status, even though they have a start date. Thanks for all your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |