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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks