PDA

View Full Version : [SOLVED] SUMIFS help please



blackie42
06-16-2017, 03:43 AM
Hi,

Might have posted in wrong place...

=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

Bob Phillips
06-16-2017, 07:56 AM
=SUMIFS(AF10:AF2000,U10:U2000,U1,AP10:AP2000,U5,AF10:AF2000,">0")

You can work out the other one.

blackie42
06-19-2017, 08:22 AM
Thanks xld,

Works good

regards
Jon