Thread: "Count non blanks" if cells don't equal certain values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
thegymshoe thegymshoe is offline
external usenet poster
  
Posts: 3
Default "Count non blanks" if cells don't equal certain values
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!
Reply With QuoteReply With Quote