Question

What is the formula of the largest sales in ecxel 2007?

Answer 1

Explanation:

✍✍✍✍Although Excel has a SUMIF function and a COUNTIF function, there is no MAXIF function.

To create your own MAXIF you can combine the MAX and IF functions in an array formula.

In this example, we'll find the highest value for a specific product in a sales list with multiple products.

Answer 2

Explanation:

There are several ways to calculate the smallest or largest number in a range. ... Select a cell below or to the right of the numbers for which you want to find the smallest number. On the Home tab, in the Editing group, click the arrow next to AutoSum , click Min