sum

K

kyoshirou

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?
 
B

Biff

Try this:

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

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

Biff
 
D

Dave Peterson

Why the new thread?
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?
Click to expand...
 
K

kyoshirou

Hi Biff,

cant..
the error is #VALUE!


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