Hi,
I need for this formula to count only positive numbers - AF10:AF10 being the column with numbers in of course.PHP Code:
=SUMIFS(AF10:AF2000,U10:U2000,U1,AP10:AP2000,U5)
and also separately negative numbers
Any help much appreciated
thanks
Jon