View Single Post
  #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.