answersLogoWhite

0

If you have numbers on two worksheets in cells A1:C23, you can use the formula:

=SUM(sheet1!A1:sheet1!C23)+SUM(sheet2!A1:sheet2!C23)

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How many worksheets are there in Microsoft Excel?

Excel 2003 and earlier are limited to 255 worksheets per workbook. There are usually 3 by default when you start Excel, but you can add more or change the default.


Can worksheets be renamed rearranged added and deleted?

Yes, it is very easy to rename, rearrange, add and delete MS Excel worksheets.


How many worksheets are present is Microsoft Excel?

Quote from the web: "According to Microsoft Excel, the number of worksheets in a workbook is "limited only by available memory." Current versions of Excel cannot use more than 1 GB of memory even if more memory is available on the system. (Excel 2007 will use as much memory as the system will give it.) In my experience, even if you could generate a well-formed workbook with 650 sheets, it is unlikely that any Excel user would be able to open it without running into Excel's memory limit. I'm impressed that you could even get to 200 sheets without a problem, honestly. "


How do you add columns in different worksheets together in Excel?

everyone knows that silly u copy and paste


Is tabs used in Excel to add worksheets columns and row titles etc?

No. That is a feature of Microsoft Word tables, but not Excel. There are specific options for inserting rows and columns in Excel.


Can you modify the number of worksheets within an Excel file?

Yes. You can add extra worksheets into a workbook. The amount is limited by the memory of your computer. By default, there are always 3 worksheets in a new workbook. It is possible to change the default.


How many worksheets can an Excel 2013 workbook have?

An Excel 2013 workbook can contain a maximum of 255 worksheets. However, the practical limit may be lower depending on the amount of available memory and system resources. Users can also add or remove worksheets as needed, allowing for flexibility in organizing data.


Can the number of worksheets in a workbook be changed in Excel?

The default amount is 3 in a new workbook but that can be changed through the options in Excel. You can add new woksheets into a workbook at any time.


What the maximum number of worksheets you can include in a workbook in Excel?

In Microsoft Excel, a new workbook will normally have three worksheets.


How many worksheets does the default setting for a new Excel workbook contain?

By default there are 3 sheets in a new Excel workbook.


What is the Short cut to add worksheets to a workbook in excel?

To quickly add a new worksheet to a workbook in Excel, you can use the shortcut Shift + F11. Alternatively, you can also click the "+" icon next to the existing worksheet tabs at the bottom of the Excel window. This allows you to create new sheets without navigating through menus.


How many work sheet add in ms Excel file?

This question is not clear. Please ask again with more specific words. I am not sure if you are asking how many worksheets you can put in a single workbook, how many add-ins are available for MS Excel, or something else.