| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
"criteria" in a sumif refering to the value in another cell
I'm trying to do a sumif with the "criteria" refering to an adjacent cell
rather than having the criteria hard keyed into the formula. For example, if I have a list of purchases by date and I want to sum up those that occured prior to 12/31/04, and 12/31/04 is the value in another cell. Can i have the sumif refer to that cell for the "criteria"? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
| How do I use ">$E$5" as the criteria using SUMIF and have it work. | Excel Worksheet Functions | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Threaded Mode
