Adding two different criteria together which are found in the column


I am trying to add up how many times "INVENTORY" is used in my column and how many times "READY2SHIP" is used in the very same column. I tried sumifs, countifs, but none of these seems to work.

Could you please assist me? The same column has several status. Only one status applies per row. I want to see how many times I see the status "INVENTORY" and the status "READY2SHIP".

I know it's not hard, but I just don't seem to be able to write the correct formula and I don't know where my mistake is. Thank you very much.

Best Answer

  • Barbara Witt
    Barbara Witt ✭✭
    Answer ✓

    @Andrée Starå Yes, I ended up developing this formula. It looks at the value at each cell and not globally at the row value.

    =COUNTIFS({Range of all devices}, @cell <> "", {Status Column}, OR(@cell = "BAD/DEFECTIVE", @cell = "Internal Use", @cell = "SCRAPPED"))

    Best regards, Barbara


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!