SUMIFS help please

Hi,

PHP Code:

---

=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

What do you want to do, SUM or COUNT?

Try

PHP Code:

---

=SUMIFS(AF10:AF2000,U10:U2000,U1,AP10:AP2000,U5,AF10:AF2000,">0") 


---

and

PHP Code:

---

=SUMIFS(AF10:AF2000,U10:U2000,U1,AP10:AP2000,U5,AF10:AF2000,"<0") 


---