COUNTIFS giving different results than applying filter on sheet

Options

I am running into a problem on calculating total counts for months of the year based on a variety of variables.


I first was using count(distinct(collect to give me unique SKU's only, but the result was not correct. Since I wasn't sure if the variables changing on different duplicate SKU's was causing the numbering screwups, I decided to live with duplicates and just use a COUNTIFS.


However I realized the COUNTIFS is also not giving correct results. I tested this by applying the same exact filters in my sheet, and its giving me a different number than the formula.


What am I doing wrong?


=COUNTIFS({SKU Detail - Parents}, <>11, {SKU Detail - Uncertain}, 0, {SKU Detail - 3D Handoff}, Month@row, {SKU Detail - Recolor}, <>"Existing", {SKU Detail - Reorder}, "")

Best Answer

  • Matt Stewart
    Matt Stewart ✭✭
    Answer ✓
    Options

    solved....


    I discovered <> does not consider blank cells. so that operator only works for column formulas that fill in data 100% otherwise you run risk of missing out on juicy stuff

Answers

  • Matt Stewart
    Matt Stewart ✭✭
    Answer ✓
    Options

    solved....


    I discovered <> does not consider blank cells. so that operator only works for column formulas that fill in data 100% otherwise you run risk of missing out on juicy stuff

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!