That's thing of beauty! <g

Near the end the column changes:

....ORDERS'!F244+'CUSTOMERS ORDERS'!G252...

Is that a typo?

Try it like this:

=SUMPRODUCT(--(MOD(ROW('CUSTOMERS ORDERS'!F4:F276)-ROW('CUSTOMERS
ORDERS'!F4),8)=0),'CUSTOMERS ORDERS'!F4:F276)

--
Biff
Microsoft Excel MVP


"excelquestions" <u53175@uwe wrote in message news:98d4f638b5de2@uwe...
I have a formula that looks like this right now:

='CUSTOMERS ORDERS'!F4+'CUSTOMERS ORDERS'!F12+'CUSTOMERS ORDERS'!
F20+'CUSTOMERS ORDERS'!F28+'CUSTOMERS ORDERS'!F36+'CUSTOMERS ORDERS'!
F44+'CUSTOMERS ORDERS'!F52+'CUSTOMERS ORDERS'!F60+'CUSTOMERS ORDERS'!
F68+'CUSTOMERS ORDERS'!F76+'CUSTOMERS ORDERS'!F84+'CUSTOMERS ORDERS'!
F92+'CUSTOMERS ORDERS'!F100+'CUSTOMERS ORDERS'!F108+'CUSTOMERS ORDERS'!
F116+'CUSTOMERS ORDERS'!F124+'CUSTOMERS ORDERS'!F132+'CUSTOMERS ORDERS'!
F140+'CUSTOMERS ORDERS'!F148+'CUSTOMERS ORDERS'!F156+'CUSTOMERS ORDERS'!
F164+'CUSTOMERS ORDERS'!F172+'CUSTOMERS ORDERS'!F180+'CUSTOMERS ORDERS'!
F188+'CUSTOMERS ORDERS'!F196+'CUSTOMERS ORDERS'!F204+'CUSTOMERS ORDERS'!
F212+'CUSTOMERS ORDERS'!F220+'CUSTOMERS ORDERS'!F228+'CUSTOMERS ORDERS'!
F236+'CUSTOMERS ORDERS'!F244+'CUSTOMERS ORDERS'!G252+'CUSTOMERS ORDERS'!
G260+'CUSTOMERS ORDERS'!G268+'CUSTOMERS ORDERS'!G276

"Customers Orders" is actually another worksheet so I know how to get the
totals already. What I want to do is a formula that looks smaller than
this
since its actually longer than this. Can someone please help me with this?