Solved

# Excel 2013 SUMIFS

Posted on 2013-10-23
331 Views
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!!
0
Question by:HDM
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 4
• 3

LVL 23

Expert Comment

ID: 39595287
Try:

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

LVL 18

Expert Comment

ID: 39595304
``````=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.
0

LVL 18

Expert Comment

ID: 39595336
@NB_VC,
Your formula reading text, not dates.  Can it be modified for numbers?
0

LVL 23

Accepted Solution

NBVC earned 500 total points
ID: 39595357
My formula is checking for blank cells vs. non blank cells.  (text or numeric)
0

LVL 18

Expert Comment

ID: 39595385
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

LVL 23

Expert Comment

ID: 39595399
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

LVL 18

Expert Comment

ID: 39595414
I think I caught it.  I had my sums in Column A... (facepalm).  Rookie mistake, my fault.  Thanks for the clarification.
0

Author Closing Comment

ID: 39612624
Thanks!!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article youâ€™ll learn how to use ExcelToWord! to copy data,charts, shapes â€¦
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.