Try
andPHP Code:
=SUMIFS(AF10:AF2000,U10:U2000,U1,AP10:AP2000,U5,AF10:AF2000,">0")
PHP Code:
=SUMIFS(AF10:AF2000,U10:U2000,U1,AP10:AP2000,U5,AF10:AF2000,"<0")
Try
andPHP Code:
=SUMIFS(AF10:AF2000,U10:U2000,U1,AP10:AP2000,U5,AF10:AF2000,">0")
PHP Code:
=SUMIFS(AF10:AF2000,U10:U2000,U1,AP10:AP2000,U5,AF10:AF2000,"<0")
Last edited by Aussiebear; 04-27-2023 at 12:16 PM. Reason: Added code tags
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber