Sumif issues

[Craig]

I'm using Excel 2002. I would like to sum the range
named "Sales" based on whether the record falls between
two dates. Can the "SUMIF" function take 2 or more
criteria, or does this have to be in an array.

So, given the following example:

Date Sales
12/31/99 100
01/01/00 100
05/01/00 100
12/01/00 100
01/01/01 100
02/01/01 100
..
..

So, I need a formula that will return, say, the sales for
the year 2000, which would be 300.

Something like the following would do, if it worked, which
it doesn't:

=SUM(IF(TransDate "between 01/01/00 and
12/31/00",Sales,0)))

Thanks for any help.

 

[Aladin Akyurek]

=SUMPRODUCT(--($A$2:$A$7>=E2),--($A$2:$A$7<=F2),$B$2:$B$7)

where A2:A7 is the date range, B2:B7 the amount/sales range, E2 the first
date condition, and F2 the second cdate condition with E2 < F2.

 

[Craig]

Thanks. What's the "--" in the formula represent, by the
way?

 

[Aladin Akyurek]

It converts the logical values (TRUE/FALSE) into their Excel numerical
equivalents (1/0).

 

[Craig]

Thanks!

-----Original Message-----
It converts the logical values (TRUE/FALSE) into their Excel numerical
equivalents (1/0).




.