Formula Too Long to Sum

**Karen615** · 07-03-2013, 10:38 AM

I am using the sum function to sum the following cells and the formula is too long. How can I make this work?
Thank you in advance.
Karen

'Raw Data'!B3,'Raw Data'!D3,'Raw Data'!F3,'Raw Data'!H3,'Raw Data'!J3,'Raw Data'!L3,'Raw Data'!N3,'Raw Data'!P3,'Raw Data'!R3,'Raw Data'!T3,'Raw Data'!V3,'Raw Data'!X3,'Raw Data'!Z3,'Raw Data'!AB3,'Raw Data'!AD3,'Raw Data'!AF3,'Raw Data'!AH3, 'Raw Data'!AJ3, 'Raw Data'!AL3, 'Raw Data'!AN3, 'Raw Data'!AP3, 'Raw Data'!AR3, 'Raw Data'!AT3, 'Raw Data'!AV3, 'Raw Data'!AX3, 'Raw Data'!AZ3, 'Raw Data'!BB3, 'Raw Data'!BD3, 'Raw Data'!BF3, 'Raw Data'!BH3, 'Raw Data'!BJ3, 'Raw Data'!BL3, 'Raw Data'!BN3, 'Raw Data'!BP3, 'Raw Data'!BR3, 'Raw Data'!BT3, 'Raw Data'!BV3, 'Raw Data'!BX3, 'Raw Data'!BZ3, 'Raw Data'!CB3, 'Raw Data'!CD3, 'Raw Data'!CF3, 'Raw Data'!CH3, 'Raw Data'!CJ3, 'Raw Data'!CL3, 'Raw Data'!CN3, 'Raw Data'!CP3, 'Raw Data'!CR3, 'Raw Data'!CT3, 'Raw Data'!CV3, 'Raw Data'!CX3, 'Raw Data'!CZ3,

**NBVC** · 07-03-2013, 10:42 AM

Try:

=SUMPRODUCT((MOD(COLUMN('Raw Data'!B3:CZ3)-COLUMN('Raw Data'!B3),2)=0)+0,'Raw Data'!B3:CZ3)

changing the CZ3 to last column to include in the sum

**shg** · 07-03-2013, 10:43 AM

Maybe ...

=SUMPRODUCT(--(MOD(COLUMN(B3:CZ3)-COLUMN(B3), 2)=0) * B3:CZ3)

**daddylonglegs** · 07-03-2013, 10:44 AM

.....or alternatively if you have a header row by which you can distinguish those columns then use SUMIF, e.g. if each of those columns has "total" in row 1 use

=SUMIF(Raw Data'!B$1:CZ$1,"total",Raw Data'!B3:CZ3)

**XOR LX** · 07-03-2013, 10:49 AM

Hi,

Try this array formula (confirm with CTRL+SHIFT+ENTER, not just ENTER) instead:

=SUM(IF(ISEVEN(COLUMN('Raw Data'!B3:CZ3)),'Raw Data'!B3:CZ3))

Regards

**Karen615** · 07-03-2013, 11:20 AM

'Raw Data'!C3,'Raw Data'!E3,'Raw Data'!G3,'Raw Data'!I3,'Raw Data'!K3,'Raw Data'!M3,'Raw Data'!O3,'Raw Data'!Q3,'Raw Data'!S3,'Raw Data'!U3,'Raw Data'!W3,'Raw Data'!Y3,'Raw Data'!AA3,'Raw Data'!AC3,'Raw Data'!AE3,'Raw Data'!AG3,'Raw Data'!AI3, 'Raw Data'!AK3, 'Raw Data'!AM3, 'Raw Data'!AO3, 'Raw Data'!AQ3, 'Raw Data'!AS3, 'Raw Data'!AU3, 'Raw Data'!AW3, 'Raw Data'!AY3, 'Raw Data'!BA3, 'Raw Data'!BC3, 'Raw Data'!BE3, 'Raw Data'!BG3, 'Raw Data'!BI3, 'Raw Data'!BK3, 'Raw Data'!BM3, 'Raw Data'!BO3, 'Raw Data'!BQ3, 'Raw Data'!BS3, 'Raw Data'!BU3, 'Raw Data'!BW3, 'Raw Data'!BY3, 'Raw Data'!CA3, 'Raw Data'!CC3, 'Raw Data'!CE3, 'Raw Data'!CG3, 'Raw Data'!CI3, 'Raw Data'!CK3, 'Raw Data'!CM3, 'Raw Data'!CO3, 'Raw Data'!CQ3, 'Raw Data'!CS3, 'Raw Data'!CU3, 'Raw Data'!CW3, 'Raw Data'!CY3, 'Raw Data'!DA3,

I thought by changing the formula to the below, it would work, but it didn't. What has to be changed in the formula to sum the cells I need?

Thank you!

=SUMPRODUCT((MOD(COLUMN('Raw Data'!C3:DA3)-COLUMN('Raw Data'!C3),2)=0)+0,'Raw Data'!C3:DA3)