PDA

View Full Version : SUMIFS help please



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

shrivallabha
07-26-2017, 05:33 AM
What do you want to do, SUM or COUNT?

Bob Phillips
07-26-2017, 06:02 AM
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")