add every other cell from another worksheet
 

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?

add every other cell from another worksheet
 

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?

add every other cell from another worksheet
 

Hi, thanks for responding. actually I think it was a typo...sorry about that..

add every other cell from another worksheet
 

You're welcome!

--
Biff
Microsoft Excel MVP


"excelquestions via OfficeKB.com" <u53175@uwe wrote in message
news:98dd66c48f2c6@uwe...
Hi, thanks for responding. actually I think it was a typo...sorry about
that..