FORMULA WITH DATES
Posted by BOB Z on January 20, 2001 9:35 PM
I like to add all items in column B that are between certain dates in column A. Result needed add all in B that are in jan 01 or between 12/01/00 & 1/3/01
A B
12/3/00 240
12/5/00 100
1/1/01 150
1/3/01 200
2/3/01 150
thank you
bob
Posted by Aladin Akyurek on January 21, 2001 8:04 AM
Array-enter (that is, hit control+shift+enter to enter)
C1 =SUM((A1:A5=VALUE("1-1-01"))*(B1:B5)) [ single criterion ]
C1 =SUM((A1:A5>=VALUE("12-01-2000"))*(A1:A5 LessThanEqualTo VALUE("01-03-2001"))*(B1:B5)) [ double criteria ]
Note. Replace LessThanEqualTo by the appropriate string of symbols.
Aladin
Posted by Carole Cronan on January 21, 2001 12:35 PM
Can this be done with a cell reference instead of a value?
Posted by Aladin Akyurek on January 21, 2001 1:49 PM
: I like to add all items in column B that are between certain dates in column A. Result needed add all in B that are in jan 01 or between 12/01/00 & 1/3/01 : 12/3/00 240 : 12/5/00 100 : 1/1/01 150 : 1/3/01 200 : 2/3/01 150 : bob
Yes.
