Which of the following functions automatically counts cells that meet multiple conditions?

a. countif
b. count
c. countifs
d. sumif

c. countifs

Explanation:

The key word in the question is "following functions automatically counts cells".  So, you can already eliminate answer D.

With COUNTIFS, you can specify multiple criteria based on as many range for consideration.

For example, count this cell, if the value in column D is bigger than 23 AND if the date in column E is lower than June 30, 2019.

It gives great power of filter and calculation to your sheet, almost as good as a database.

go to edit profile and on the ; eft hand side it has a bunch of options and the very last on says profile picture, click the blue edit sign next to it

answerpixels;