# Adding a COUNTIF to a COUNTIFS formula?

I have a COUNTIFS formula... =COUNTIFS(Status:Status, CONTAINS("In Progress - On Track", @cell)). I have another formula that I need to add to the =COUNTIFS forumula... it's =COUNTIF(Level:Level, =0) . How would I combine the two?

Tags:

• The formula below will count the cells where both criteria are met.

```=COUNTIFS(Status:Status, CONTAINS("In Progress - On Track", @cell),Level:Level, =0)
```

if your goal is to add up the 2 results found by each COUNTIF, use the following formula

```=COUNTIF(Status:Status, CONTAINS("In Progress - On Track", @cell)) + COUNTIF(Level:Level, =0)
```
• It worked!!! Thank you!

• The formula below will count the cells where both criteria are met.

```=COUNTIFS(Status:Status, CONTAINS("In Progress - On Track", @cell),Level:Level, =0)
```

if your goal is to add up the 2 results found by each COUNTIF, use the following formula

```=COUNTIF(Status:Status, CONTAINS("In Progress - On Track", @cell)) + COUNTIF(Level:Level, =0)
```
• It worked!!! Thank you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!