| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total columns of one sheet on another sheet
Try this on your summary sheet:
=SUM(data!B:B,data!M:M,data!X:X,data!AI:AI) Hope this helps. Pete On Jan 21, 3:55*pm, Tash wrote: I have several different columns with different people I need to total the columns per person on a different sheet Sheet name is data and summary I want columns B,M,X,AI to total on the summary sheet Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if < on one tab - want total on a summary sheet | Excel Worksheet Functions | |||
| moving informatiion from one sheet to a total sheet | Excel Discussion (Misc queries) | |||
| How to make columns in one sheet match columns from another sheet | Excel Discussion (Misc queries) | |||
| Take 3 columns, one per sheet and turn it into one on 4th sheet | Excel Worksheet Functions | |||
| Cell Total shown Sheet to Sheet | New Users to Excel | |||
Threaded Mode
