Hi John,

Am Fri, 8 Jul 2011 05:20:49 -0700 (PDT) schrieb John Sofillas:

The 1st formula would go into cell D45. I need it to return the sum of
P42, V42, AB42, and so on all the way out to DH42 (17 total cells).
The 2nd formula would go into cell D46. I need it to return the sum of
Q42, W42, AC42 and so on all the way out to DI42 (17 total cells).
Keep in mind that as I delete columns DH and DI, and DB and DC and so
on all the way back, that the formulas in D45 and D46 still continue
to work.

first formula:
=SUMPRODUCT(--(MOD(COLUMN(P42:DI42),6)=4),P42:DI42)
second formula:
=SUMPRODUCT(--(MOD(COLUMN(P42:DI42),6)=5),P42:DI42)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2