answersLogoWhite

0

Use the SUM function and separate each range with a comma.

EXAMPLE:

=SUM(A1:A23,B1:B23)

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Shall we extend the number of columns in a Microsoft Excel work sheet?

Can not be done. Your version of Excel has a fixed maximum number of columns available. However, if you just want to include more available columns in an existing worksheet, just insert columns, as needed.


What is Excel and Entourage?

Excel is a Microsoft software designed to calculate formulas and is in a spreadsheet layout. Entourage is the Mac version of Microsoft Outlook.


What is row range?

in Microsoft 2007 range are as follows:1,048,576 rows and 16,384 columns and in earlier version it is around 65000 or so. i think this is sufficient for you


How many collum are there in a sheet?

The number of columns on an Microsoft Excel Sheet varies depending on the version of operating software. For the 2007 and 2010 versions the number of columns available is 16,384 while other versions only 256.


How many columns in microsoft 2007?

The last cell in Excel 2007 is XFD 1,048,576 There are 16,384 columns and 1,048,576 rows.


When did Microsoft Access come out?

The first version of Microsoft Access came out in 1992.The first version of Microsoft Access came out in 1992.The first version of Microsoft Access came out in 1992.The first version of Microsoft Access came out in 1992.The first version of Microsoft Access came out in 1992.The first version of Microsoft Access came out in 1992.The first version of Microsoft Access came out in 1992.The first version of Microsoft Access came out in 1992.The first version of Microsoft Access came out in 1992.The first version of Microsoft Access came out in 1992.The first version of Microsoft Access came out in 1992.


Is there an end to Microsoft Excel?

Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.Yes. There are a limited amount of rows and columns. Up to version 2003, that was 256 columns and 65, 536 rows. Since Excel 2007, it has been increased to 16,384 columns and 1,048,576 rows.


What is the total number of rows in Microsoft Excel 2010?

In Excel 2010 the number of rows per worksheet is 1,048,576 and the number of columns is 16,384 which is column XFD. That makes 17,179,869,184 cells.


What is the most current Windows Media Player?

The most current Microsoft Windows Media Payer is version 12. This version however is only version in the latest version of Microsoft Windows - version 8.


Does Excel has 26 columns?

No. Excel has a lot more than that. It depends on your version, but it will have at least 256 columns and up to 16,384 columns.


How many columns are there in Excel if the last one is labeled XFD?

16,384 columns can be found in versions of Excel from version 2007 onwards. That is column XFD. If it is an earlier version the last column is IV and there are 256 columns.


What is the next version of Microsoft Flight Simulator?

The next version of Microsoft Flight Simulator is Microsoft Flight. It is being released spring 2012.