Using SUMIF to have a blank cell if data comes back zero

01/30/21
Accepted

I am pulling data from another sheet. I am using a SUMIF to sum things off a certain date and if it meets a certain name. When it has no data to bring back, it shows a zero and I would like for the cell to be blank so that my charts do not show a lot of zeros. How can I do this? Thanks



=SUMIFS({AIC-Diverts 2020 Range 1}, {Defect Month}, [email protected], {WOF-WOP Range 1}, Da[email protected], {Defect Shift}, "VTIS 1")

Best Answers

Answers

  • Mark CronkMark Cronk ✭✭✭✭✭
    Accepted Answer

    =IF(SUMIFS({AIC-Diverts 2020 Range 1}, {Defect Month}, [email protected], {WOF-WOP Range 1}, [email protected], {Defect Shift}, "VTIS 1") =0, "", SUMIFS({AIC-Diverts 2020 Range 1}, {Defect Month}, [email protected], {WOF-WOP Range 1}, [email protected], {Defect Shift}, "VTIS 1")


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Accepted Answer

    Thank you. It works well.

  • Mark CronkMark Cronk ✭✭✭✭✭

    Hi @Mike Arbaugh ,

    Excellent. Glad you found a solution. Please accept my answer to close out the discussion. Thank you for contributing to the Community.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Sign In or Register to comment.