A subtraction


I am getting an error message #ParSEABLE with the formula below, the values are coming from the below link as you can see in the second snapshot

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Shannon Lacerda

    It looks like you need to separate SUMIF statements, then minus one from the other.

    For example:

    =SUMIF(formula) - SUMIF(formula)

    Try this:

    =SUMIF({Actual Billing Job}, [Job/ Opp#]@row, {Actual Billing (Total Billings) Jan}) - SUMIF({Forecasted Billing(Cashflow) Job}, [Job/ Opp#]@row, {Forecasted Billing(Cashflow) Jan})

    Let me know if this works for you!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!