Home excel account in the range of two conditions

# account in the range of two conditions

Author

Date

Category

1y column – a list with repeating values ​​(text).

2nd column – values ​​(numbers).

3d column – desired values.

Is it possible to make the formula to calculate the number of cells of non-equal 0 from the second column for each value from the first column?

There are silent, but values ​​will be summed up, and you just need count.

``````aaa 0 1
AAA 4 1.
Aaa 0 1.
BBB 0 0.
BBB 0 0.
CSS 0 3.
CSS 1 3.
CSS 3 3.
CSS 0 3.
CSS 1 3.
``````

``````cx = countable (\$ a \$ y: \$ A \$ z; ax; \$ b \$ y: \$ b \$ z; "& lt; & gt; 0")
``````

where:

• x – current line
• y, z – the initial and final lines of the data table

In principle, if there is nothing on top-bottom, it is possible and just

``````cx = countable (\$ A: \$ a; ax; \$ b: \$ b; "& lt; & gt; 0")
`````` as option

``````= sample (- (\$ A \$ 2: \$ A \$ 99 = A2); - (\$ b \$ 2: \$ b \$ 99 & lt; & gt; 0))
``````

sometimes saves, but for this task it is better to apply `8 `

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.