Thread: "Count non blanks" if cells don't equal certain values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default "Count non blanks" if cells don't equal certain values
=256-COUNTBLANK(1:1)-COUNTIF(1:1,"AA")-COUNTIF(1:1, "UE")-COUNTIF(1:1,"UA")

--
Gary''s Student - gsnu200858
Reply With QuoteReply With Quote