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.