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"? |
#2
|
|||
|
|||
=SUMIF(rng,"<="&cell_ref,rng_to_sum)
eg =SUMIF(A1:A100,"<="&C1,B1:B100) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "mark" wrote in message ... 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"? |
Reply |
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 |