@SUMIF and Using Dates as Criteria

[scottlloyd33]

Columnar Data looks like:

1/25/2001 $10.00 $20.00
8/5/2001 $10.00 $20.00
5/10/2000 $20,00 $40.00
12/25/1999 $40,00 $80.00

My problem -- I don't want to hard-wire my date criteria into the formula -- I want it to go look at cell. Say A5 that has the date 12/31/2001 -- I want to formula to look like the following:

@Sumif(a1..a3,<=Cell A5,b1..b3)

What is necessary format for the criteria?

My first try at Mr. Excel -- so please be kind -- lol

 

[Aladin Akyurek]

On 2002-10-08 14:35, scottlloyd33 wrote:
Columnar Data looks like:

1/25/2001 $10.00 $20.00
8/5/2001 $10.00 $20.00
5/10/2000 $20,00 $40.00
12/25/1999 $40,00 $80.00

My problem -- I don't want to hard-wire my date criteria into the formula -- I want it to go look at cell. Say A5 that has the date 12/31/2001 -- I want to formula to look like the following:

@Sumif(a1..a3,<=Cell A5,b1..b3)

What is necessary format for the criteria?

My first try at Mr. Excel -- so please be kind -- lol

The formula is:

=SUMIF(A1:A3,"<="&A5,B1:B3)

 

[scottlloyd33]

Thanks -- worked like a champ. I had tried it that way -- but got errors. Actually my spreadsheet was in 123 and I thought (hoped) the formulas would be the same -- but Lotus returned errors.