Yes, the date range is F3,G3,H3 merged together. The cell containing
the date - CY2 would for example contain 06/05/2006. So the formula
would sum every 3rd column; starting with the first column in the range
F5:CO5 who's date is less than or equal to the date 06/05/2006.
Biff, your formula worked except I had to add a less than sign. <=CY2.
=SUMPRODUCT(--(MOD(COLUMN($F5:$CO5),3)=0),--(F3:CO3=CY2),$F5:$CO5)
Thanks fellas.
ep
--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread:
http://www.excelforum.com/showthread...hreadid=557980