P.S. sorry, I got the "positive/negative" mixed up, but I think you can
figure it out.

"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