answersLogoWhite

0

SUMIFS was new in Excel 2007.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How many functions are in Microsoft Excel 2007?

348, at my count


How many functions can be nested with the same formula in MS Excel?

Excel 2003 = 8 levels of nesting Excel 2007 = 64 levels of nesting


What are the3 lookup functions in excel 2007?

LOOKUP, HLOOKUP and VLOOKUP.


What are some differences between Excel 2003 and Excel 2007?

The most obvious visible difference is the ribbon bar (new menu system) displayed by all Office 2007 products. You also will notice a new file format. Excel 2003 uses an extension of XLS, while Excel 2007 uses the extension of XLXS, You can open Excel 2003 files in Excel 2007, but not the other way around. Excel 2007 adds many new functions. See related links for what's new with Excel 2007. Also see the related links for how to match the old Excel 2003 menu items with the new Excel 2007 ribbon.


How many columns in 2003 and 2007?

In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.


How do you open a worksheet in Microsoft Excel 2007?

You can open a worksheet in excel by following methods:Open the file from File menu.Open the file by double clicking on the file.


How do you find mini tab in Excel 2007?

It is stated that the Minitab functions as a dedicated statistical-analysis tool. Some of the ways to find the Minitab in Excel 2007 is by migrating the graph, pasting the graph, or by pressing Ctrl-C.


How do you count cells that has values above 5000 for a1 to g1 in Microsoft Excel 2007?

To count only numbers that exceed a particular value use the COUNTIF function. In your example, where the numbers to be counted are in the range A1:G1 use the following formula: =COUNTIF(A1:G1,">5000")


What are 5 different groups of functions provided by Microsoft Excel 2007?

Financial, Date & Time, Engineering, Statistical and Text.


Do you need the basics in Excel 2003 to learn Excel 2007?

Not necessarily. Having a good understanding of Excel 2003 will help in using Excel 2007. The main difference is the look, but the fundamentals are the same as it is still a spreadsheet, so it has to be able to do things that spreadsheets do, like with the formulas and functions. As those things are much the same, then you could use Excel 2007 without having ever used Excel 2003. Users of Excel 2003 would find Excel 2007 a little strange at first because of how different it looks, although they would quickly get used to it. Someone who has never used Excel 2003 won't have that problem.


How Excel 2007 Converted to Excel 2003?

You can open a 2007 Excel spreadsheet with Excel 2003 if you save the file in Excel 2007 using "Save As" and select the 2003 compatibility mode.


Can you use Excel 2010 as Excel 2007?

The differences between them are not extensive so you can work in Excel 2010 easily if you are familiar with Excel 2007. You can save your files so that Excel 2007 will recognise them.