| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add every other cell from another worksheet
Hi, thanks for responding. actually I think it was a typo...sorry about that..
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
| If in specific cell in any worksheet but worksheet one add to spec | Excel Worksheet Functions | |||
| Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
| How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
| Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions | |||
Hybrid Mode
