Share via

Why is the SUMIF function returning zero instead of the sum range that met the criteria?

Anonymous
2025-04-11T11:15:55+00:00

Using the SUMIF function, I want to evaluate the Month (A2:A89) column and get the sum of the Inbound calls(B2:B89) in a given month that met the criteria, but it keeps returning zero.

This is the formula i tried.

=SUMIF(A2:A89, Month(A2)=1, B2:B89)

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2025-04-11T12:36:59+00:00

    You cannot specify a condition that way.

    Try this:

    =SUM($B$2:$B$89*(TEXT($A$2:$A$89, "mmm")=G2))

    This can be filled down.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2025-04-11T12:38:50+00:00

    D2: =SUMPRODUCT((MONTH(A2:A16)=1)*B2:B16)

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2025-04-11T19:02:14+00:00

    Thank you very much, Andreas. This is very helpful.

    0 comments