sumproduct in a given year
Thanks it worked
"Biff" wrote:
Hi!
Try this:
A1 = 31/12/2005
=SUMPRODUCT(--(YEAR(B17:B53)=YEAR(A1)),C17:C53)
Biff
"Bumblebee" wrote in message
...
Hi, can someone help me with this:
the following formula works:
SUMPRODUCT((YEAR(B17:B53)=2005)*(C17:C53))
if I stick in the year in the formula, e.g. 2005 as in above. But when I
reference it to another cell that puts 31/12/2005 I get 0 as an answer.
How
do I get it to understand that I am interested in the 2005 bit. I don't
know
if I am making myself understood. I want to sume a list of things in a
given
year, 2004, 2005, but the year part referenced to another cell that has
the
date looking like this 31/12/aaaa
Thanks
|