answersLogoWhite

0

Yes. You can use the SUMIF function. Suppose you wanted to add all the cells in the range from B2 to B15 that have values greater than 50:

=SUMIF(B2:B15,">50")

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What function adds the cells specified by a given condition or criteria?

The SUMIF function in Excel adds cells based on a single condition or criteria. If you have multiple conditions, you can use the SUMIFS function instead.


What is the Excel formula for adding how many of a category?

It sounds like you are asking about the SUMIF function. SUMIF adds all numbers in a range of cells, based on a given criteria.=SUMIF(range,criteria,sum_range)range = range of cells that you want to apply the criteria against.criteria = determines which cells to add.sum_range = range of cells to sum.


What function return the number of entries in a range based on given criteria?

The function that returns the number of entries in a range based on given criteria is the COUNTIF function in Excel. It counts the number of cells that meet a specific condition within a specified range. For example, COUNTIF(A1:A10, ">5") would count how many cells in the range A1 to A10 contain values greater than 5. For multiple criteria, you can use COUNTIFS, which allows for multiple conditions across different ranges.


What function counts the number of cells within a range that meets the given condition?

The COUNTIF function in Excel counts the number of cells that meet a specific criterion within a range. You specify the range and the criteria, and it returns the count of cells that meet that condition.


What is a possible value?

A possible value is a specific number or result that is within the range of acceptable or expected outcomes for a given variable or scenario. It represents a potential option or solution that fits the criteria being considered.


What happens when cells are given nutrients?

When cells are given nutrients, they metabolize them, and grow and divide to create more cells. If they are not given nutrients, they die.


What is DCOUNT?

DCOUNT is like COUNT, except that it works on an Excel Database or List. It returns the number of cells in a column or or a field of a database that contains numbers and meets a given criteria. It needs the full list or database, a specified field to count values from and criteria that uses one or more fields.


Who can help Turkey's application for membership of the EU?

They have to do it for themselves. They have been given the criteria that they have to meet to join the EU. It is up to them to meet those criteria.


Which Four Digit Number contains Four Different Digits and meets the following Criteria?

That of course must depend on the criteria which has not been given.


What is x if multiply by zero and result is 1275?

There is no possible value of x that will satisfy the given equation. There is no possible value of x that will satisfy the given equation. There is no possible value of x that will satisfy the given equation. There is no possible value of x that will satisfy the given equation.


How do a judge a modeling show?

The judges are given specific instructions on what criteria to look for and go from there.


The criteria that a given college uses for admissions are generally called?

college entrance requirements