Quote:
Originally Posted by Excel Dumbo
Hi Spencer,
Thanks a lot for your repliy. I tried your formula and it worked, it gives me the result. But, it leads to another problem . I have explained this below
For Eg Example- Result "Jul-12" is in Worksheet1 cell B1
On Worksheet2 , cell DG25 is linked to the B1 of Worksheet 1
I have a formula below
=SUMPRODUCT(($H$20:$BE$20=$DG$26)*($H$21:$BE$21<=$ DG$25)*($H28:$BE28))
which pulls out the cumulative values from Jan to Jul (H$21:$BE$21<=$DG$25) When I apply your formula mentioned in the earlier post, my formula in Worksheet 2 gives me values only till June. The big formula is supposed to give me values from Jan to July and not just Jan to June.
Hope you understood the problem, as I am working on a big file, I am not able to attach it here due to size restrictions.
Kindly advise.
|
Try this in place of the formula I gave you earlier.
=EOMONTH(DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)),0)
If this doesn't work, it's because you're using 2003 or earlier and do not have the analysis toolpak installed.
Let me know if it works. If not I will sort out a workaround for you.
Of course, if that does work you could just use
=EOMONTH(A1,12) for the same thing. Again, swap A1 in the formula for your relevant cell.
S.