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
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
Last edited by Aussiebear; 04-27-2023 at 12:16 PM. Reason: Added code tags