SUMIFS help please

[blackie42]

Hi,

Might have posted in wrong place...

=SUMIFS(AF10:AF2000,U10:U2000,U1,AP10:AP2000,U5)

I need for this formula to count only positive numbers - AF10:AF10 being the column with numbers in of course.

and also separately negative numbers

Any help much appreciated

thanks
Jon

[Bob Phillips]

=SUMIFS(AF10:AF2000,U10:U2000,U1,AP10:AP2000,U5,AF10:AF2000,">0")

You can work out the other one.

[blackie42]

Thanks xld,

Works good

regards
Jon