Adding values when certain criteria is met

Hello, I am trying to figure out how to add values from one cell, when certain criteria is met in 2 other cells. Example: Add values from "Forecast Value" cell, when "Sales Status" cell is Closed Won and "Date Received" cell is for a particular month. April=04/01/22

Best Answer

  • Michael Culley
    Michael Culley ✭✭✭✭✭
    Answer ✓

    That means there's an error so the iferror statement makes errors show as blanks.

    What if you tried this formula instead?

    =SUMIFS({Archive-Mathew Truster Leads Range 1}, {Archive-Mathew Truster Leads Range 2}, "Closed Won", {Archive-Mathew Truster Leads Range 3},IFERROR(MONTH(@cell), 0) = 1)

    Also you should get into the practice of naming your ranges and not using the default names. Leaving the default range names can cause random circular reference errors out of the blue for no reason at all.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!