Locate particular months sale with year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=SUMPRODUCT(--(MONTH(b7:b400)=MONTH(D417)), --(YEAR(b7:b400)=YEAR(D417)))
best wishes
 
Back
Top