Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF
I can not get this to give me a value other then 0
{=SUM(IF('reference data'!$E$2:$E$125,"=1",IF('reference data'!$I$2:$I$125, "=1",'reference data'!$A$2:$A$125)))} I got this from the excel help An array formula can perform multiple calculations and then return either a single result or multiple results. Array formulas act on two or more sets of values known as array arguments. Each array argument must have the same number of rows and columns. You create array formulas the same way that you create basic, single-value formulas. Select the cell or cells that will contain the formula, create the formula, and then press CTRL+SHIFT+ENTER to enter the formula. the brackets are added once I do the ctrl shift enter -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200510/1 |
#3
|
|||
|
|||
Assuming that Column E and Column I contain numerical values, try...
=SUM(IF('reference data'!$E$2:$E$125=1,IF('reference data'!$I$2:$I$125=1,'reference data'!$A$2:$A$125))) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article <55be7dc70cc63@uwe, "CCTD via OfficeKB.com" <u14229@uwe wrote: I can not get this to give me a value other then 0 {=SUM(IF('reference data'!$E$2:$E$125,"=1",IF('reference data'!$I$2:$I$125, "=1",'reference data'!$A$2:$A$125)))} I got this from the excel help An array formula can perform multiple calculations and then return either a single result or multiple results. Array formulas act on two or more sets of values known as array arguments. Each array argument must have the same number of rows and columns. You create array formulas the same way that you create basic, single-value formulas. Select the cell or cells that will contain the formula, create the formula, and then press CTRL+SHIFT+ENTER to enter the formula. the brackets are added once I do the ctrl shift enter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |