Hi,

=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