thmh

asked on

# COUNTIFS doesn't count numbers excel

hy,

why COUNTIFS formula doesn't count numbers criteria in ranges

example:

=COUNTIFS(A1:A3,5,D1:D3,1,F1:F3,2) = 2 ( it should be 8 )

A D F

5 4 2

5 1 2

5 1 2

why COUNTIFS formula doesn't count numbers criteria in ranges

example:

=COUNTIFS(A1:A3,5,D1:D3,1,

A D F

5 4 2

5 1 2

5 1 2

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER