In Y1 =SUMPRODUCT((A1:X1)*(A1:X1<0))
In Z1 =SUMPRODUCT((A1:X1)*(A1:X10))
--
HTH...

Jim Thomlinson


"PattiP" wrote:

I have a row of 24 numbers, A1:X1. I would like Y1 to SUM only those cells
if they have negative numbers in them and Z1 to SUM only those cells that
have positive numbers. Thanks!
--
Patti