Adding entries if date entered in another column

[Jen]

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.

 

[Pete_UK]

Here's two ways:

=SUMIF(B:B,"active",C:C)

or:

=SUMIF(D,"<>",C:C)

Hope this helps.

Pete

 

[xlmate]

try this formula in the total cell

=SUMPRODUCT((D26<>"")*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
(e-mail address removed)

 

[Jen]

Thanks!
I had it close but I was missing the <>
=SUMIF(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.

 

[Jen]

I did not try your suggestion, as the first post worked, but thanks so much
for your help!

 

[xlmate]

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
(e-mail address removed)

 

[Pete_UK]

You're welcome, Jen - thanks for feeding back.

Pete