bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
Hello all below is my formula
=SUMPRODUCT(--(MONTH('G.S - Report'!$K$8:$K$65536)=MONTH(D10)),--(YEAR('G.S - Report'!$K$8:$K$65536)=YEAR(D10)),('G.S - Report'!$N$8:$N$65536))
D10 = 30-May-2011 ....it shows the first monday of every week (drop down list)
basically, im trying to show month-to-date invoice count, so using sum product, however, 30 may is monday, 31 is tues and 1 june is wednesday.....so pretty much my sumproduct is summing only month of may, when it should use may + june in this instance....
can someone pls help!
thx u
=SUMPRODUCT(--(MONTH('G.S - Report'!$K$8:$K$65536)=MONTH(D10)),--(YEAR('G.S - Report'!$K$8:$K$65536)=YEAR(D10)),('G.S - Report'!$N$8:$N$65536))
D10 = 30-May-2011 ....it shows the first monday of every week (drop down list)
basically, im trying to show month-to-date invoice count, so using sum product, however, 30 may is monday, 31 is tues and 1 june is wednesday.....so pretty much my sumproduct is summing only month of may, when it should use may + june in this instance....
can someone pls help!
thx u
