using formula =SUMIF(range, criteria)

for that range and criteria, can we apply using date instead of range?
Such that we the date can be arrange from year 06. So that all information
fall under 06 will auto add up.

any tips?

Try this:

Dates in the range A1:20
Values to sum in the range B1:20

=SUMPRODUCT(--(YEAR(A1:A20)=2006),B1:B20)

Biff

"kyoshirou" wrote in message
...
using formula =SUMIF(range, criteria)

for that range and criteria, can we apply using date instead of range?
Such that we the date can be arrange from year 06. So that all information
fall under 06 will auto add up.

any tips?

Hi Biff,

cant..
the error is #VALUE!


Hi Dave,
posting another one with no details for easy input.




"Biff" wrote:

Try this:

Dates in the range A1:20
Values to sum in the range B1:20

=SUMPRODUCT(--(YEAR(A1:A20)=2006),B1:B20)

Biff

"kyoshirou" wrote in message
...
using formula =SUMIF(range, criteria)

for that range and criteria, can we apply using date instead of range?
Such that we the date can be arrange from year 06. So that all information
fall under 06 will auto add up.

any tips?

Why the new thread?

kyoshirou wrote:

using formula =SUMIF(range, criteria)

for that range and criteria, can we apply using date instead of range?
Such that we the date can be arrange from year 06. So that all information
fall under 06 will auto add up.

any tips?

--

Dave Peterson