I have K2, T2, AC2, AL2, and AV2 with numbers in them. I want to count how many of those are greater than zero. For instance, K2 is 4, T2 is 17, AC2 is 0, AL2 is 3, and AV2 is 6. I would expect an answer of 4, because 4 out of 5 cells is greater than zero. I have tried multiple formulas, all returning errors. So if I use countif, and my range is the cells K2, T2, AC2, AL2, and AV2 and my criteria is >0 I get an error. Help please?

3

Consider the following formula.

```
=(K2>0)+(T2>0)+(AC2>0)+(AL2>0)+(AV2>0)
```