SUMPRODUCT formula to differentiate between Negative and Positive
 

Hi,

I have a formula as follows:

=SUMPRODUCT((E6:E56="uk")*G6:G56)

But i'd like to separate it into two cells, one picking up negative figures
in the G column, and the other picking up the positive figures.

Any ideas??

Much Appreciated.

SUMPRODUCT formula to differentiate between Negative and Positive
 

=SUMPRODUCT(--(E6:E56="uk"),--(G6:G56=0),G6:G56)

Change =0 to <0 for negative numbers


--


Regards,


Peo Sjoblom




"carol" wrote in message
...
Hi,

I have a formula as follows:

=SUMPRODUCT((E6:E56="uk")*G6:G56)

But i'd like to separate it into two cells, one picking up negative
figures
in the G column, and the other picking up the positive figures.

Any ideas??

Much Appreciated.

SUMPRODUCT formula to differentiate between Negative and Posit
 

Thanks so much, that worked!


"Peo Sjoblom" wrote:

=SUMPRODUCT(--(E6:E56="uk"),--(G6:G56=0),G6:G56)

Change =0 to <0 for negative numbers


--


Regards,


Peo Sjoblom




"carol" wrote in message
...
Hi,

I have a formula as follows:

=SUMPRODUCT((E6:E56="uk")*G6:G56)

But i'd like to separate it into two cells, one picking up negative
figures
in the G column, and the other picking up the positive figures.

Any ideas??

Much Appreciated.