SUMIFS help please

[blackie42]

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

[shrivallabha]

What do you want to do, SUM or COUNT?

[Bob Phillips]

Try

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

and

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