Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I use a cell reference in the criteria for the sumif function.
If I use "32" as the criteria in my sumif formula, I receive the correct
answer. If I use C3 as the critera, I receive zero as the answer. Is some way to use a cell reference in the criteria? Excel help says that the criteria can be a "number, expression, or text." |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
HOW DO I REFERENCE A CELL FROM THE RESULTS OF TWO WORKSHEETS | Excel Discussion (Misc queries) | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) |