View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scossa Scossa is offline
external usenet poster
 
Posts: 26
Default 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