# COUNTIFS formula troubleshooting - multiple criteria and checkboxes

Options
✭✭

Hi SmartSheets Community,

I'm new to Smartsheet (but know some basic Excel), but am getting stumped on this formula. Can you advise what I'm doing wrong?

I'm trying to create a formula that 1) counts either Red or Blue cells in another spreadsheet column (Other Sheet Range 1), and then 2) counts a checkmark (or no check mark). When I enter this in, I get #UNPARSEABLE. Any guidance on what I'm doing wrong?

Checkmark formula:

=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, =1))

No Checkmark formula:

=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 0))

Tags:

• ✭✭✭✭✭✭
Options

Try the below: (You had an extra parenthesis at the end in both the formula and also changed =1 to just 1)

```=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 1)

=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 0)
```

• ✭✭✭✭✭✭
Options

Try the below: (You had an extra parenthesis at the end in both the formula and also changed =1 to just 1)

```=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 1)

=COUNTIFS({Other Sheet Range 1}, OR(@cell = "Red", @cell = "Blue"), {Other Sheet Range 5}, 0)
```
• ✭✭
Options

Thank you Sameer!! This was driving me crazy, and I couldn't figure it out. Appreciate it!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!