Automating a computation process
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))
Copy to D E F
Bye!
Scossa
|