Please enable JavaScript to view the comments powered by Disqus.


COUNTIFS(...(...C4:C13),(...">"&"30"),(...B4:B13),(..."Girls"))

Using COUNTIFS() with multiple criteria

The formula takes multiple lookup values and corresponding ranges to yield the final count.


Used Functions

Category: Statistical

Counts the number of cells within a range that meet multiple criteria

Syntax

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Practice COUNTIFS Formula at Sheetzoom COUNTIFS formula at Microsoft help

Lets chat on this


© 2023 Sheetzoom       Legal Stuff         Made with    in Istanbul

   START LEARNING EXCEL with SHEETZOOM