Which of the following can be used to find the total number of lines with data in a column, based on 2 different requirements?

Sumifs
Totalifs
Countif
Countifs

1 answer

To find the total number of lines with data in a column based on two different requirements, you should use Countifs.

  • Countifs allows you to count the number of rows that meet multiple criteria across one or more ranges.

Countif is used for a single criterion, while Sumifs and Totalifs (though Totalifs is not a standard function in Excel) are not designed for counting rows based on criteria.

Therefore, the correct choice is Countifs.