SUMIF using 2 cells that equal each other
in [General]
|
From: wormburner on 4 Feb 2010 15:07 I am using SUMIF to add cells in a column but the criteria I want to use is add the cell only if the criteria equals another cell. I do not want to enter the actual variable of the cell as it changes for each row of column C. As an example: =SUMIF('A2:A5001,"C2",D2:D5001) where "C2" equals a variable that can change. Is there any function I can use for the variable?
From: Mike H on 4 Feb 2010 15:18 You almost had it, try this =SUMIF(A2:A5001,C2,D2:D5001) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "wormburner" wrote: > I am using SUMIF to add cells in a column but the criteria I want to use is > add the cell only if the criteria equals another cell. I do not want to enter > the actual variable of the cell as it changes for each row of column C. > > As an example: =SUMIF('A2:A5001,"C2",D2:D5001) where "C2" equals a variable > that can change. > > Is there any function I can use for the variable?
|
Pages: 1 Prev: Conditional Formatting No Longer Working Next: IF THEN formulas |