D
dannycombs
I'm trying to evaluate a date, contained in cell C1, against an array o
dates, contained in column A. Specifically, I'm using SUMIF to add u
dollar figures in column B when there corresponding date, in column
is early than the reference date in C1.
SUMIF(A1:A5,"<=C1",B1:B5)
If I explicity state the date in the formula such as
"<=4/26/2005"
but I need to compare it to the date contained in the reference cell s
I can easily change it. When I try the former it doesn't work. Th
resultant sum is zero as if no dates in the column A array met th
criteria, even though they do.
Can anybody tell me how to make this work?
Thanks,
Dann
dates, contained in column A. Specifically, I'm using SUMIF to add u
dollar figures in column B when there corresponding date, in column
is early than the reference date in C1.
SUMIF(A1:A5,"<=C1",B1:B5)
If I explicity state the date in the formula such as
"<=4/26/2005"
but I need to compare it to the date contained in the reference cell s
I can easily change it. When I try the former it doesn't work. Th
resultant sum is zero as if no dates in the column A array met th
criteria, even though they do.
Can anybody tell me how to make this work?
Thanks,
Dann