View Single Post
  #4   Report Post  
Domenic
 
Posts: n/a
Default


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