| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumifs - greater than criteria with a Cell Reference
2007 excel sumifs problem,
I am trying to us a sumif with multiple ranges and criteria but am having on bug, with cell referenceing when using it with a greater or less than criteria. Example sumifs(sum range, criteria range, <(G6)) where G6 equalls and input cell. When I substitiute G6 with "<10" it works but when using a cell reference instead of 10, nothing works. Thanks. David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIFS formula using dates and text as criteria | Excel Discussion (Misc queries) | |||
| sumifs will not work with a cell reference as criteria | Excel Discussion (Misc queries) | |||
| Using wildcards in criteria for sumifs functions | Excel Discussion (Misc queries) | |||
| sort data rows "greater than or equal" criteria in another cell | Excel Worksheet Functions | |||
| increase a cell reference by increments greater than one... | Excel Worksheet Functions | |||
Threaded Mode
