Excel 2013 SUMIFS

Is there a way to sum column A if column M has a date but column N does not??

Basicly I am trying to show a sum if a lesson is begun but not completed.

So Column M would have a lesson begin date and column N would have a lesson completed date.

Thanks!!
Curtis LongAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
My formula is checking for blank cells vs. non blank cells.  (text or numeric)
0
 
NBVCCommented:
Try:

=SUMIFS(A:A,M:M,"<>",N:N,"")
0
 
Steven HarrisPresidentCommented:
=SUMIFS(A:A,M:M,">1",N:N,"")

Open in new window


This will only SUM the numbers in Column A if the same row in Column M has a value and Column N does not have a value.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Steven HarrisPresidentCommented:
@NB_VC,
Your formula reading text, not dates.  Can it be modified for numbers?
0
 
Steven HarrisPresidentCommented:
It doesn't seem to work for me.  Using your formula, I am returned a higher value, which is why I suggested ">1".  It also returns "0" if I put the formula in here.

See attached, I may be missing something.
SUMIFS.xlsx
0
 
NBVCCommented:
You have the formula in column A causing a circular reference because you are using whole column ranges...

try:

=SUMIFS(A1:A25,B1:B25,"<>",C1:C25,"")
0
 
Steven HarrisPresidentCommented:
I think I caught it.  I had my sums in Column A... (facepalm).  Rookie mistake, my fault.  Thanks for the clarification.
0
 
Curtis LongAuthor Commented:
Thanks!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.