Saved Bookmarks
| 1. |
Solve : placing cell references in SUMIF function in Excel? |
|
Answer» This: =SUMIF($C$2:$C$1631,"<112",$D$2:$D$1631) returns the number i expect it to RETURN, the sum of all the values in the range D2:D1631 that correspond to the values in C2:C1631 that are below 112. however, when i type 112 into cell L2, and try this: =SUMIF($C$2:$C$1631,"i get 0 every time. same with: =SUMIF($C$2:$C$1631,"<(L2)",$D$2:$D$1631) =SUMIF($C$2:$C$1631,"<($L2)",$D$2:$D$1631) =SUMIF($C$2:$C$1631,"<($L$2)",$D$2:$D$1631) =SUMIF($C$2:$C$1631,"<(L$2)",$D$2:$D$1631) =SUMIF($C$2:$C$1631,"<"L2"",$D$2:$D$1631) =SUMIF($C$2:$C$1631,"=SUMIF($C$2:$C$1631," I need to be able to change one cell and have many cells that have functions similar to that SUMIF function respond CORRECTLY. i CANT just go in and change the "112" to "101" or whaever on every cell that has a SUMIF function. Any thoughts? Thanks, Try it this WAY... =SUMIF($C$2:$C$1631,"<"&L2,$D$2:$D$1631) Adding that AMPERSAND should make your cell reference work. |
|