Insert the DMAX function in cell N4 to calculate the highest sales based on the criteria entered in range G2:K3.
1 answer:
In the excel spreadsheet, the way for one to be able to calculate the highest sales based on the criteria entered in range G2:K3 is by:
- First select cell N3 and then click on the formula tab. Then also select insert function and then click on Database, select DAVERAGE. Use A2:E52 as range, then do type "highest sales" and G2:K3.
Highest Sales is a term that connote the highest from of Qualifying Revenue that is gotten in course of a given period of time (1 year).
In the excel spreadsheet, there are different kinds of shortcut that are often used to make the calculations of works to be very easy.
Thus, In the excel spreadsheet, the way for one to be able to calculate the highest sales based on the criteria entered in range G2:K3 is by:
- First select cell N3 and then click on the formula tab. Then also select insert function and then click on Database, select DAVERAGE. Use A2:E52 as range, then do type "highest sales" and G2:K3.
Learn more about sales from
#SPJ1
You might be interested in