=AVERAGEIFS(C2:C64,A2:A64,"Blue",B2:B64,"Black") Returns an Average of Column C of the Items Which
=AVERAGEIFS(C2:C64,A2:A64,"Blue",B2:B64,"Black")
Returns an average of Column C of the items which are either Blue or Black.
Correct Answer:
Verified
Q68: The _ function returns the forecasted values
Q69: This formula will successfully count all green
Q70: Two or more conditions can be used
Q71: The Greek letter mu is the symbol
Q72: The arguments for COUNTIFS, SUMIFS, AVERAGEIFS are
Q74: _ returns the forecasted values for a
Q75: Inferential statistics and Descriptive statistics are the
Q76: The k argument in a PERCENTILE function
Q77: The FREQUENCY function determines the strength of
Q78: The Significance argument in a PERCENTRANK function
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents