COUNTIF / AND functions
the COUNTIF and AND functions are already combined for you in the COUNTIFS
function.
COUNTIFS(range1, criteria1, range2, criteria2, etc). it will only count the
number of times that all conditions are met at the same time.
i'm no expert but hope that helps took me a while before i figured that out
too.
|