Hi Garry,

Am Fri, 25 Apr 2014 12:33:56 -0400 schrieb GS:

=IF(OR(AND(MONTH(ThisDate)=MONTH(NextDate),NextDat e<""),This_ET=""),"",SUMPRODUCT(--(MONTH(B$3:ThisDate)=MONTH(ThisDate)),--($D$3:ThisProject=ThisProject),$H$3:This_ET))

..as well as updated the CF to use defined names instead of cell
addresses.

thank you for the information. I will look for the new version.


Regards
Claus B.

For some reason the 'Upload new version' action didn't/doesn't work and
so I just deleted/re-uploaded since your post...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion