Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Sumif with dates for range criteria
0 views
Skip to first unread message
Chad Linders
Sep 20, 2003, 4:49:17 PM9/20/03
to
I would like to sum values in a column if values/dates in
a respective column are "less than" current date. When I
enter the following, I do not get an error, but I get "-"
for a sum:
a respective column are "less than" current date. When I
enter the following, I do not get an error, but I get "-"
for a sum:
=sumif(a1:a12,"<b20",b1:b12)
where cell b20 has current date.
Any help would be appreciated.
Thanks,
Chad
Debra Dalgleish
Sep 20, 2003, 5:01:21 PM9/20/03
to
Change your formula to put the cell reference outside of the quotation
marks:
marks:
=SUMIF(A1:A12,"<"&B20,B1:B12)
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Aladin Akyurek
Sep 20, 2003, 4:58:24 PM9/20/03
to
It's:
=sumif(a1:a12,"<"&b20,b1:b12)
"Chad Linders" <Lin...@chartermi.net> wrote in message
news:01ec01c37fb8$a84833c0$a401...@phx.gbl...
Alan Beban
Sep 20, 2003, 5:06:23 PM9/20/03
to
Try
=SUMIF(A1:A12,"<"&B20,B1:B12)
Alan Beban
0 new messages