View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aladin Akyurek Aladin Akyurek is offline
external usenet poster
 
Posts: 52
Default Counting Non Blank Cells that Contain Formulas

If formulas return text...

=COUNTIF(Range,"?*")

or numbers:

=COUNT(Range)

jimswinder wrote:
Is there a way to count cells that contain formulas, but only those cells
that return a value. I tried using COUNTA...but that sees the ceel as
nonblank also.