| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumifs will not work with a cell reference as criteria
Where cells M12 and M15 contain the number 39315 and 39317, respectively.
The formula yields no results when M12 and M15 are in the formula. However, when I substitute the actual number in the formula, the proper result is produced. =SUMIFS(G2:K2,$G$1:$K$1,"=M12",$G$1:$K$1,"<=M15") does not work =SUMIFS(G2:K2,$G$1:$K$1,"=39315",$G$1:$K$1,"<=393 17") works |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference cell in one TAB from another using two criteria | Excel Worksheet Functions | |||
| COUNTIF cell reference won't work | Excel Worksheet Functions | |||
| Can I set the criteria in a sumif statement as a cell reference? | Excel Worksheet Functions | |||
| IF Function Does Not Work With Cell Reference | Excel Worksheet Functions | |||
| SUMPRODUCT Criteria Via Cell Reference?? | Excel Worksheet Functions | |||
Threaded Mode
