Could you please help me automating a process in EXCEL for the following
problem.
I have data arranged in the following format:

1/A B C D E F G
2 ColA ColB ColC ColD Population
3 25 68 20 93 78
4 48 48 100 94 24
5 20 4 26 53 46
6 37 12 92 93 10
7 80 6 31 27 91
8 85 42 96 56 76
9 1 8 88 82 78
10 3 24 59 20 63
11 97 89 45 53 94
12
13 Negative
14 Positive




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.

Is there a function that will automatically compute this across ColA through
ColD.
Thank you in anticipation.

Jack

Hi,

Try this

=SUMPRODUCT(1*(A3:A11-B3:B11<0))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"jack" wrote in message
...


Could you please help me automating a process in EXCEL for the following
problem.
I have data arranged in the following format:

1/A B C D E F G
2 ColA ColB ColC ColD Population
3 25 68 20 93 78
4 48 48 100 94 24
5 20 4 26 53 46
6 37 12 92 93 10
7 80 6 31 27 91
8 85 42 96 56 76
9 1 8 88 82 78
10 3 24 59 20 63
11 97 89 45 53 94
12
13 Negative
14 Positive




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.

Is there a function that will automatically compute this across ColA
through
ColD.
Thank you in anticipation.

Jack

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

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