Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
countif two corresponding cells meet the criteria | Excel Worksheet Functions | |||
Count Cells that meet Criteria | Excel Worksheet Functions | |||
Sum Total # Of Cells That Meet Several Criteria | Excel Worksheet Functions | |||
Adding cells that meet certain criteria | Excel Programming | |||
Adding the sum of figures in one column if they meet 2 criteria | Excel Worksheet Functions |