SUMPRODUCT formula to differentiate between Negative and Positive

[carol]

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.

 

[Peo Sjoblom]

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

Change >=0 to <0 for negative numbers


--


Regards,


Peo Sjoblom

 

[carol]

Thanks so much, that worked!

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

Change >=0 to <0 for negative numbers


--


Regards,


Peo Sjoblom