I didn't ge this to work. I put in ten months- 1-10 in columns A1:A10
and it still added all ten months vs giving me through august only.
any suggestions?
Thanks for trying!
Tina
VBA Noob wrote:
Hi,
Assume
A1 is July date B1 is July Value
A1 is Aug date B2 is Aug Value
etc
=SUMPRODUCT(--(--(MONTH(A1:A4))<=(MONTH(TODAY()))),--(--(B1:B4)))
VBA Noob
--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569936