"Count non blanks" if cells don't equal certain values
If you want to exclude only the three values you mentioned then try
=COUNTA(B1:B9)-COUNTIF(B1:B9,"EE")-COUNTIF(B1:B9,"UA")-COUNTIF(B1:B9,"UE")
You can comeup with more elegant formulas but all of them will essentially
do the same process...
Adjust the range according to your data.
Click 'Yes' if this helped.
"thegymshoe" wrote:
I need to figure out a formula that counts the non blanks in a row, but omits
non blanks equalling "UA", "UE" and "AA".
Can anyone give me a simple formula please, I've tried all sorts of IFs,
AND's and MAYBE's thanks!
|