Adding entries if date entered in another column

J

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.
 
P

Pete_UK

Here's two ways:

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

or:

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

Hope this helps.

Pete
 
X

xlmate

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

Jen

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.
 
J

Jen

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top