LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jen Jen is offline
external usenet poster
 
Posts: 119
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding double quotes around entries in a column NCdesigner Excel Discussion (Misc queries) 6 December 12th 08 08:34 PM
Adding suffix to column entries NCdesigner Excel Worksheet Functions 5 October 13th 08 03:49 PM
Adding up entries in one column with conditions in two columns The Fool on the Hill Excel Discussion (Misc queries) 5 February 5th 07 03:37 PM
Sum Column Entries that fall within Date Range Listed In Rows Ben Excel Worksheet Functions 4 July 10th 06 05:43 PM
Adding a column based on greater than a date Toni G. Excel Worksheet Functions 4 March 17th 05 08:06 PM


All times are GMT +1. The time now is 10:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"