Formula Needed
Posted by Steve on January 14, 2002 4:55 AM
A1=Start Date B1=End Date C4=Any Date(Will change) I would like to sum the numbers in A2:A4 if the Date in C4 falls between these two dates in A1 and B1.
Posted by Aladin Akyurek on January 14, 2002 5:09 AM
Steve --
You didn't state the lay-out of your data clearly, but I reckon you want something like this:
=SUMIF(dates-range,">="&cell-ref-of-the-criterion-start-date, numbers-range)-SUMIF(dates-range,">"&cell-ref-of-the-criterion-end-date,numbers-range)
which computes according to an inclusive between.
Aladin
========
Posted by Steve on January 14, 2002 5:30 AM
Aladin, In cell A1= 1/10/01 in Cell B1 2/31/01 and A2=$5.00, A3= $6.00, A4= $1.00 now if Cell C4=1/11/01 (date will change) I would like to add the numbers in A2:a4 if C4 fall in between A1 and B1.
Posted by Aladin Akyurek on January 14, 2002 5:49 AM
Still unnclear to me: What do you have in C2 and in C3?
Posted by Aladin Akyurek on January 14, 2002 6:02 AM
=IF(AND(C4 > A1, C4 < B1), SUM(A2:A4),0)
what you're looking for?
Aladin
=========
Posted by Steve on January 14, 2002 6:06 AM
