# How do I COUNTIF and SUMIF cells whose value is not a specific text? [closed]

Hello

I am trying to find out how many cells in a column that does not contain a specific text.

```
=COUNTIF(B1:B1002;"<>Text")
```

This returns "TRUE", not how many cells is counted.

I also would like to use this with SUMIF

```
=SUMIF(B1:B1002;"<>Text";D1:D9999)
```

But this also returns true, and not the sum of all cells in D where B column has not "text".'

The cells which contain functions probably have boolean type. Everything except 0 is True.