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