Locate particular months sale with year

[Rao Ratan Singh]

I m using =SUMPRODUCT(--(MONTH(b7:b400)=MONTH(D417))) this function to locate
particular month's sale from my sale book, but when i change only year it
does not work and result shows same. How it can be locate particular months
sale with year

 

[Bernard Liengme]

=SUMPRODUCT(--(MONTH(b7:b400)=MONTH(D417)), --(YEAR(b7:b400)=YEAR(D417)))
best wishes

 

[Rao Ratan Singh]

Thank you sir,
it is working.