Re: $$Excel-Macros$$ Code for range shifting based on month

see if it helps cell c3 enter this formula =SUMPRODUCT(--($A$104:$A$65536>=DATE(LEFT($A3,4),RIGHT($A3,2),1)),--($A$104:$A$65536wrote: > Dear all, > > I have a spreadsheet containing daily customer transaction data. I have > used SUMIF to find out the monthly customer transaction data. > However,

$$Excel-Macros$$ Code for range shifting based on month

Dear all, I have a spreadsheet containing daily customer transaction data. I have used SUMIF to find out the monthly customer transaction data. However, it is tedious to copy the formula and paste for next month when next month comes. Can anyone suggest any VBA code / idea to help shifting the