Automating a computation process

J

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
 
S

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

get a list of sequence number that meet 3 criteria 0
Unique values in a macro 1
Sumproduct 3
Advice sought: Multiple column sorting 3
Auto calculate 1
I need BIG help with with formula 2
help 1
Transpose Macro 0

Top