=SUMIF(A2:A25;"<38353";B2:B25)-SUMIF(A2:A25;"<37987";B2:B25)
or
=SUMPRODUCT((A2:A25<38353)*(A2:A25=37987)*(B2:B25 ))
--
David Biddulph

"Igor" wrote in message
...
Hi

Is it possible to use AND in SUMIF function. I have a simple table with
three columns. The first column contains dates in chronological order. I
want to use SUMIF function to sum values from the second column but only
for a specific period of time (ie one year).
For example: =SUMIF(A2:A25;"<38353";B2:B25) sums all values before year
2005, so 2004, 2003, etc.. How should the function look like to sum values
only for one year, 2004 for instance.

Kind regards