writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 90:
Line 90: − + − + − + − +
→Examples
= DAVERAGE(A3:D7,"Price",A1:B2) : Calculates the average price of Pens in the range A3 to D7, for the cells with Quantity>10. Returns '''66.66499999999999''' as a result.
= DAVERAGE(A3:D7,"Price",A1:B2) : Calculates the average price of Pens in the range A3 to D7, for the cells with Quantity>10. <br>Returns '''66.66499999999999''' as a result.
= DAVERAGE(A3:D7,2,A1:B2) : Calculates the average number of Pens in the range A3 to D7, for the cells with Quantity>10. Returns '''21''' as a result.
= DAVERAGE(A3:D7,2,A1:B2) : Calculates the average number of Pens in the range A3 to D7, for the cells with Quantity>10. <br>Returns '''21''' as a result.
= DAVERAGE(A3:D7,"Quantity",A3:D7) : Calculates the average number of all items in the range A3 to D7. Returns '''21.75''' as a result.
= DAVERAGE(A3:D7,"Quantity",A3:D7) : Calculates the average number of all items in the range A3 to D7. <br>Returns '''21.75''' as a result.
= DAVERAGE(A3:D7,4,A3:D7) : Calculates the average of percentage profit of all the items in the range A3 to D7. Returns '''3''' as a result.
= DAVERAGE(A3:D7,4,A3:D7) : Calculates the average of percentage profit of all the items in the range A3 to D7. <br>Returns '''3''' as a result.
== Related Videos ==
== Related Videos ==