answersLogoWhite

0

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")

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

What do letters and number represent in Microsoft Excel?

They can represent values in cells. They also can represent columns (letters) and rows (numbers).


How do you remove hash tags in cells Microsoft Excel?

The hash tags appear because the cells are not wide enough to show their contents. You just need to widen the cells to show the values.


What is a radio on Microsoft Excel?

A radio button is a form control. It is usually part of a set where one can selected but no others. You can link them to cells to set values for them.


When you are proposing a range to sum Excel firsts looks for a range of cells with numbers above the active cell then to the right?

If you use the Autosum, Excel will try to detect cells that are above or right of it. If there are figures both immediately above it and immediately right of it, then it will try to sum the ones immediately above it. However, using the Autosum you can select a block of cells and Excel will put totals at the end of them, again opting for the bottom if columns of cells are involved, so you could select a row of values or a column of values. You can also just manually type in the cells you want to sum.


What group of cells chosen in Microsoft Excel is chosen to perform an action?

A range of cells, that can then be used in a function. The cells from B2 to E13 could be a range of cells that you want to total all the values in: =SUM(B2:E13)


How many cells are in the range c4 to f12 in Microsoft Excel?

36


Do statistical functions ignore blank cells in Microsoft Excel?

Yes it does.


How many cells are in Microsoft Excel 2007?

There are 16,384 columns (A - XFD) and 1,048,576 rows, for a total of 17,179,869,184 cells per worksheet in Excel 2007.


What is semi-selection in excel?

A semi-selection in Microsoft Excel is the action of selecting a few cells in a worksheet. To select the cells, you would click on them to highlight.


What is a function to find the number of values in cells?

In Excel is it COUNT.


Verical lines in Microsoft Excel are called in microsoft EXcel?

The actual lines are known as gridlines, both vertical and horizontal. A vertical line of cells is known as a row.


What is the function of the cell refrance in Microsoft Excel?

In order to do formulas that use values in cells, you need to be able to refer to those cells in the formulas. That is what a cell reference does. You can then create formulas that can be copied quickly and be used for any values that may appear in the cells. As much as possible cell references, rather than values, should be used in formulas.