add every other cell from another worksheet

E

excelquestions

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?
 
T

T. Valko

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)
 
E

excelquestions via OfficeKB.com

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