SUMIF using 2 cells that equal each other
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? |
SUMIF using 2 cells that equal each other
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? |
All times are GMT +1. The time now is 06:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com