Forum Discussion
COUNTIFS
Hi, I have a table showing concentrations for a lot of samples. Every sample has a specified type (A, B, C) and sub type (x, z). Finaly, there are alert limits depending on the concentration (lev...
Take the cell references $D15 and $E15 out of the quotes:
=NB.SI.ENS($G15:$CO15;"<>-";$G$9:$CO$9;"*A*";$G15:$CO15;">="&$D15;$G15:$CO15;"<"&$E15)