Try...
=SUMPRODUCT(--(MOD(COLUMN(F4:L4)-COLUMN(F4),3)=0),--(F4:L40),F4:L4)
Hope this helps!
AlDeb Wrote:
What do I do if the three columns I am summing are F4, I4, & L4??? The
three columns are not all together.
--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=388652