On 30 Set, 10:42, Scossa wrote:
On 30 Set, 05:55, jack wrote:

In Cells C13 to C14, I want to get the results of the counts if the
differenc e (e.g., ColA-Population, ColB-Population, etc.) is negative or
positive.

In C13:: =MATR.SOMMA.PRODOTTO(1*(C3:C11-$G$3:$G$11<0))
In C14:: =MATR.SOMMA.PRODOTTO(1*(C3:C11-$G$3:$G$110))

In C13:: =SUMPRODUCT(1*(C3:C11-$G$3:$G$11<0))
In C14:: =SUMPRODUCT(1*(C3:C11-$G$3:$G$110))

Apologize!

Bye!
Scossa