Formula Not Updating

Options

I am using the following formula cannot get it to pull the data. It pulled it once but now it is coming back as 0 and will not update.

=COUNTIFS({Medxcel Fire Invoices Range 7}, 1, {Medxcel Fire Invoices Range 6}, 1)

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Hi @Amy Broeker ,

    First, confirm that your ranges point to the single column data you want counted. Then try:

    =COUNTIFS({Medxcel Fire Invoices Range 7}, @cell= 1, {Medxcel Fire Invoices Range 6}, @cell=1)

    Work?

    Mark


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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!