| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding cells that meet certain criteria
in Y1
=SUM(IF(A1:X10,A1:X1)) in Z1 =SUM(IF(A1:X1<0,A1:X1)) NOTE: after entering the formulas you must hold down both the Shift and Ctrl keys at the same time, then press Enter (Ctrl+Shift+Enter). You will see the formula in curly braces if you do it correctly. This gives you an "array formula" to calclulate on the whole range. {=SUM(IF(A1:X10,A1:X1))} "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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding cells that meet certain criteria
Thanks to you both !!!!
-- Patti "Charlie" wrote: in Y1 =SUM(IF(A1:X10,A1:X1)) in Z1 =SUM(IF(A1:X1<0,A1:X1)) NOTE: after entering the formulas you must hold down both the Shift and Ctrl keys at the same time, then press Enter (Ctrl+Shift+Enter). You will see the formula in curly braces if you do it correctly. This gives you an "array formula" to calclulate on the whole range. {=SUM(IF(A1:X10,A1:X1))} "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif two corresponding cells meet the criteria | Excel Worksheet Functions | |||
| count cells that meet 2 criteria | Excel Worksheet Functions | |||
| Count Cells that meet Criteria | Excel Worksheet Functions | |||
| Can I sum #s in a cell if other cells meet a certain criteria? | Excel Discussion (Misc queries) | |||
| Adding the sum of figures in one column if they meet 2 criteria | Excel Worksheet Functions | |||
Linear Mode
