Automating a computation process

[jack]

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

 

[Ashish Mathur]

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Scossa]

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$11>0))

Copy to D E F

Bye!
Scossa

 

[Scossa]

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

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

Apologize!

Bye!
Scossa