Formula not working - correctly

Ozu

I tried applying a formula, but the results aren’t coming out correctly. For example, the headset count is showing as 6, whereas there are actually only 3 headsets.

I suspect the issue is due to multiple items being listed in a single cell (e.g., "Headset, Keyboard"). Could someone please confirm if the formula supports multi-select values within a cell, or suggest an alternative approach?

Appreciate your help!

KPH

Hi

Your current COUNTIFS will only count rows where the value in Range 6 matches exactly that in the primary column.

If you use the HAS function, you can count the rows where the value of the primary column is one of the multi selected options.

https://help.smartsheet.com/function/has

Replace

[Primary Column}@cell

With

HAS(@cell, [Primary Column}@cell)

KPH

Hi

Your current COUNTIFS will only count rows where the value in Range 6 matches exactly that in the primary column.

If you use the HAS function, you can count the rows where the value of the primary column is one of the multi selected options.

https://help.smartsheet.com/function/has

Replace

[Primary Column}@cell

With

HAS(@cell, [Primary Column}@cell)

Ozu

That worked thanks @KPH.

😇

Really greatful, else was thinking to add figures manually.

KPH

Great news, thanks for letting me know.