COUNTIFS function
When trying to count the number of cells containing one and the second value, the function returns 0
aaabbccc
=COUNTIFS(A1:A8;”a”;A1:A8;”b”)
When trying to count the number of cells containing one and the second value, the function returns 0 aaabbccc=COUNTIFS(A1:A8;”a”;A1:A8;”b”) Read More