SUMIFS not calculating values-giving result as "0"

Mindfull

Hi,

I am using following SUMIFS, though it is not throwing any error but it is not calculating the values in required range:

=SUMIFS({Deliverables}, {Engg}, Resource@row, {Completion Month}, Month@row, {Status}, Status@row)

Can anyone please help me know know, where I am missing on writing the argument?

Thank you,

Prajna

Bassam Khalil

Hi @Prajna J

Hope you are fine, could you please add a screenshot ( remove any sensitive data )

Paul Newcome

What kind of data is in the {Deliverables} range? Is it numeric values?

Mindfull

@Paul Newcome Deliverable in number are there and the column properties is set as Text/Number.

Mindfull

One more update when I am using SUMIF it is working:

=SUMIF({Engg}, Resource@row, {Deliverables})

Paul Newcome

If the SUMIF is working then that narrows down the issue to one of these sets:

{Completion Month}, Month@row,

and/or

{Status}, Status@row

What exactly is in each of the ranges and each of the columns referenced? Do you have a formula populating the {Completion Month} range? If so, what is it?

Mindfull

Here is the formula I am using for the {Completion Month}:

=IFERROR(IF(MONTH([Finalized Date]@row) = 1, "January", IF(MONTH([Finalized Date]@row) = 2, "February", IF(MONTH([Finalized Date]@row) = 3, "March", IF(MONTH([Finalized Date]@row) = 4, "April", IF(MONTH([Finalized Date]@row) = 5, "May", IF(MONTH([Finalized Date]@row) = 6, "June", IF(MONTH([Finalized Date]@row) = 7, "July", IF(MONTH([Finalized Date]@row) = 8, "August", IF(MONTH([Finalized Date]@row) = 9, "September", IF(MONTH([Finalized Date]@row) = 10, "October", IF(MONTH([Finalized Date]@row) = 11, "November", IF(MONTH([Finalized Date]@row) = 12, "December")))))))))))) + " " + YEAR([Finalized Date]@row), "")

Paul Newcome

And what exactly is in the Month column?

{Completion Month}, Month@row,

Mindfull

It is text MONTH YEAR ...e.g., January 2021.

Paul Newcome

Ok. What about the Status range and column?

Mindfull

Range has drop downs and Status@row is text.

Paul Newcome

I would start by making sure that the text matches exactly in both sheets to include spaces. You may need to go into individual cells to check as multiple spaces are not shown when viewing a cell but are shown when editing.