=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.