Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Formulas in next sheet
Name: naseer Date: January 4, 2008 at 22:16:32 Pacific OS: Windows XP CPU/Ram: Celeron 2 GHZ 384 MB of Product: Intel
Comment:
Dear All I want to make summry sheet of my statistics in a separate sheet, how can I execute for example, sum, count, if, average, etc. of one or two sheets in a third sheet to summarize things.
Name: Bryco Date: January 5, 2008 at 05:24:00 Pacific
Reply:
You simply create the formulas the same as you would in a single sheet but refer to the cells in the other sheet.
The easist way to refer to cells in another sheet is to simply switch to the other sheet and click into the referenced cell. Excel will know it's sheet reference information rather than typing it into the formula.
HTH Bryan
0
Response Number 2
Name: DerbyDad03 Date: January 5, 2008 at 19:50:37 Pacific
Reply:
It should look something like this when you are done:
Summary: - Right click the sheet tab. - The bottom choice should be View Code (at least in Version 2003 and earlier) - Click View Code - A blank VBA Editor window should open. - Paste the code from my earlier...
Summary: Hello I used the formula in another way Each row have a label in the left representing the sheet no. it summarizes as per the below formula cell A7 contains the sheet name that i want it's summary =VL...
Summary: ertw= estimated return to work. This colume will most always have a date to start a case. ertw/ld= estimated return to work light duty. This colume may not get a date, or, will be awhile( weeks ) befo...
0 
