year/month

[red]

Hi,
I am trying to search an array and sum the values in a column where the year
and month = my criteria. I can do it for just the mounth using
:-=SUMPRODUCT(--(MONTH($I$4:$I$100)=COLUMNS(A1:L1)),$H$4:$H$100), but i now
have data for more than one year so i need to add a year search as well.
Can anybody help?

 

[Bernie Deitrick]

=SUMPRODUCT(--(MONTH($I$4:$I$100)=COLUMNS(A1:L1)),--(YEAR($I$4:$I$100)=2009),$H$4:$H$100)

 

[red]

Thanks Bernie, works a treat!!

=SUMPRODUCT(--(MONTH($I$4:$I$100)=COLUMNS(A1:L1)),--(YEAR($I$4:$I$100)=2009),$H$4:$H$100)