# Conditional row sum

I'd like to sum a column of cells if the corresponding cell on the next column contains a string of any sort. I've tried using `SUMIF` but I can't figure out how to combine it with `ISBLANK` or `ISTEXT`.

For example, in this case the function should output 12.

``````---------
| 5 | x |
---------
| 6 |   |
---------
| 7 | y |
---------
``````

Here's the formula you need

`````` =SUMIF(ARRAYFORMULA(ISTEXT(B1:B3)),TRUE,A1:A3)
``````

## First parameter :

Range (required) - the range of cells that should be evaluated by criterion.

The formula expects a range. This is why `ISTEXT(B1:B3)` alone doesn't work because it returns a single Boolean `FALSE`.

To return a range, you need to use `ARRAYFORMULA()`
I.E : `ARRAYFORMULA(ISTEXT(B1:B3))` returns this

``````--------
| TRUE |
--------
| FALSE|
--------
| TRUE |
--------
``````

## Second parameter :

Criterion (required) - the condition to be met

You choose when a value will be `SUM`; in this case it's when `ISTEXT()` returns `TRUE`

## Third parameter :

Sum_range (optional) - the range in which to sum numbers. If omitted, then range is summed.

In our case the range we are testing is different from the range we want to sum.