blackie42
06-15-2017, 12:42 PM
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
=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