You're welcome!

--
Biff
Microsoft Excel MVP


"Minitman" wrote in message
...
Hey Biff,

I've not used MOD before and had no idea what it did, now I know.

Thanks.

-Minitman




On Fri, 11 Apr 2008 16:53:54 -0400, "T. Valko"
wrote:

=SUM(B2:CC2)
get the sum from every third cell?

So, every 3rd cell would be B2, E2, H2, K2, etc?

If you will *never* insert new columns in front of the range:

=SUMPRODUCT(--(MOD(COLUMN(B2:CC2),3)=2),B2:CC2)

If you might insert new columns in front of the range:

=SUMPRODUCT(--(MOD(COLUMN(B2:CC2)-COLUMN(B2),3)=0),B2:CC2)