View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PattiP PattiP is offline
external usenet poster
 
Posts: 10
Default Adding cells that meet certain criteria

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