Curtis Long
asked on
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!!
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!!
=SUMIFS(A:A,M:M,">1",N:N,"")
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.
@NB_VC,
Your formula reading text, not dates. Can it be modified for numbers?
Your formula reading text, not dates. Can it be modified for numbers?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
See attached, I may be missing something.
SUMIFS.xlsx
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,"" )
try:
=SUMIFS(A1:A25,B1:B25,"<>"
I think I caught it. I had my sums in Column A... (facepalm). Rookie mistake, my fault. Thanks for the clarification.
ASKER
Thanks!!
=SUMIFS(A:A,M:M,"<>",N:N,"