If you want to calculate the average number of customers you have had over the past month, what would the syntax of your formula look like?
a. AVERAGE(number1, [number2,...])
b. CALCULATE(number1,number2,...])
c. AVERAGE(numberx,numberxx,...)
d. CALCULATE(number1, [number2,...])
Microssoft excel help question#5. please computer friends?
None of the above. My formula would be a vlookup() to determine which days had customers, a if("","",countif()) to determine the total count and then a averagea(sum()) to determine the average of the cells without blanks.
Reply:c
send flowers
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment